Hi spool watchers,
As an exercise i picked up a user request that runned in 53 minutes with an actual spool of 1,5 TO (query monitor V14.10) and tried to optimize.
After explaining the query and adding recommended statistics on tables i was able to get an explain with spool estimations reduced to 200 GO at most (among 4 spools).
At last i runned the request and got the answerset in 1 minute and 20 seconds, with a spool of 25 GO (Qrylog).
How to match that unique value in the log and the estimated values in explain ?
Thanks for "explaining",
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.