|
|
Browse by Tags
All Tags » Undocumented » Internals » Seeks (RSS)
-
The following table summarizes the results from my last two blog entries, showing the CPU time used when performing 5 million clustered index seeks:
In test 1, making the clustered index unique improved performance by around 40%. In test 2, making the same change reduced performance by around 70% (on 64-bit systems – more on that later). ...
-
If you look up Table Hints in Books Online, you’ll find the following statement: If a clustered index exists, INDEX(0) forces a clustered index scan and INDEX(1) forces a clustered index scan or seek.
If no clustered index exists, INDEX(0) forces a table scan and INDEX(1) is interpreted as an error. The interesting thing there is ...
|
|
|
|