note
mpeppler
With Sybase you'd use the <code>optdiag</code> tool to get information about index statistics and index distribution, and to load simulated index statistics.<p>
To see query plans you use <code>set showplan on</code>, 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).<p>
Michael
307205
307253