Clear questions and runnable code get the best and fastest answer |
|
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
With Sybase you'd use the optdiag tool to get information about index statistics and index distribution, and to load simulated index statistics.
To see query plans you use set showplan on, and dbcc traceflags 302 and 310 are used to get a full explanation of the choices made by the optimizer (very useful when the optimizer decides to do things that seem very counter-intuitive to you). Michael In reply to Re: Re: Re: Re: Use Placeholders. For SECURITY and (sometimes) for PERFORMANCE
by mpeppler
|
|