Pathologically Eclectic Rubbish Lister | |
PerlMonks |
Re: Re: Re: Re: Use Placeholders. For SECURITY and (sometimes) for PERFORMANCEby mpeppler (Vicar) |
on Nov 15, 2003 at 01:16 UTC ( [id://307276]=note: 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 Section
Meditations
|
|