Viewing 3 posts - 1 through 3 (of 3 total)
Hi Brian.
I tried the query on different pc's and all the results except the CPU time varied.
My best guess is that the CPU resources available is playing havoc.
The CPU time is...
December 1, 2005 at 12:00 am
The text result is the same as the grid's result.
I tried the various multiple queries and the result stays the same: unclustered is faster. Everything I know about indexes is...
November 30, 2005 at 7:12 am
You are right, the clustered index should be better.
I've just tested the records with a clustered index on a datetime field in the table, which is totally unrelated to...
November 30, 2005 at 6:32 am
Viewing 3 posts - 1 through 3 (of 3 total)