Is it true for ORDER BY clause too?
quote:But, if you DONT have a where clause (I know, you ought to have one), a table scan is the fastest...
Thanks a ton!
I might need some help understanding the article, though!
The where clause tip was an interesting one.
Do we have a formula (involving the number of records in the table) to compute the...
I have posted a new thread for this...
I got another doubt related to indexes -
I understand that, in heaps, the data is not stored in any order and SQL Server has to access the...
I have got another doubt related to indexes (may be I should start a new thread, but, just in case it's a short reply) -
What is the cost...
Thanks to Roji and Adriaan.
This discussion has been very helpful to me!
I am still tracking it, though always on a look out for more...
So, it means that if I add a column to a clustered index, it becomes non-clustered?
Just wanted to make sure if you meant "clustered" index there instead of "non-clustered"...
quote:I'd recommend adding a column to the...
Well, as Roji pointed out that 4 bytes for every row are taken up by the uniquefier, can there be a reason/situation...
In what circumstances should we consider adding a composite column to a non-unique clustered index in order to make the index unique, rather...
Separate names with a comma.