|
|
|
| The stupid question is the question not asked | |
| PerlMonks |
Re: Re: Re: Re: Use Placeholders. For SECURITY and (sometimes) for PERFORMANCEby mpeppler (Vicar) |
| on Nov 14, 2003 at 20:16 UTC ( [id://307276]=note: print w/replies, xml ) | Need Help?? |
This is an archived low-energy page for bots and other anonmyous visitors. Please sign up if you are a human and want to interact.
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
|
|
||||||||||||||||||||||||