All Forums Database
dagen 2 posts Joined 09/12
15 Dec 2015
Analysis of skew of spool files

Hi
As spool file is one of the usual issue of complex queries or queries run upon large data sets, It would be good to have chance to look at skew of spool files. If it was a chance to somehow check/calculate skew of spool file - even if it is per query and steps of the query, it would be more than useful.
In fact, as there is a lot of spool files created by running a select, it would be good to know at least in which step of a query a spool file issue appears. Or, ideal state, to have information about skew of a specific spool.... whatever of this kind ...
Thanks,
Dag

dnoeth 4628 posts Joined 11/04
15 Dec 2015

Hi Dag,
if StepInfo is enabled QryLogStepsV will show details including spool for each step

Dieter

You must sign in to leave a comment.