July 3, 2002 at 7:30 am
Hello,
Can someone tell me with cinfidence how rows are located for deletion on a table with a clustered index. Is the Index used, or is the table scanned.
Thanks
July 3, 2002 at 7:44 am
It depends on how the query plan works out.
Andy
July 3, 2002 at 10:10 am
The clustered index will eventually be used, either directly or with a bookmark lookup since it contains the data. However the actual choice depends, as Andy says, on the query plan.
why?
Steve Jones
July 3, 2002 at 11:07 pm
Hi
Thanks for your replies. I just wanted to know because this particular table will have 60 million rows when mature. There are no updates, just insert and deletes.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply