|
Posted by jim.clifford on 10/19/06 09:33
I have been using display execution plan (of query analyser). This is
how I known if the task performed in 'top', 'sort', 'seek' and 'index
scan'. These tasks I correlate with durations taken.
So the questions still remain;
Problem 1) Why is the smaller index only involving 'timestamp' not used
when it's available and covers the details on the query involved ?
Problem 2) Why does the introduction of a simple computed column
dis-able the optimiser?
Regards JC.......
Navigation:
[Reply to this message]
|