May 13, 2011 at 11:38 am
While i am looking at the index structure, i was wondering is it possible to avoid nc-index scan when it is doing and update? Also does clustered index gets updated only when a portion on table in updated?
May 13, 2011 at 11:42 am
sqldba_icon (5/13/2011)
While i am looking at the index structure, i was wondering is it possible to avoid nc-index scan when it is doing and update? Also does clustered index gets updated only when a portion on table in updated?
Yes you can avoid the nc scan... but the real question is is it too costly??
The clustered index IS the data. So you can't NOT update it.
May 13, 2011 at 3:04 pm
Ninja's_RGR'us (5/13/2011)
sqldba_icon (5/13/2011)
While i am looking at the index structure, i was wondering is it possible to avoid nc-index scan when it is doing and update? Also does clustered index gets updated only when a portion on table in updated?Yes you can avoid the nc scan... but the real question is is it too costly??
The clustered index IS the data. So you can't NOT update it.
Oh yeah, scanning entire table (11 million rows) using a nc index. I will get you some more details, but it is using a scan in "Case" statement. Is this normal behaviour to scan in case statement?
May 13, 2011 at 3:20 pm
Not surprised, please post the query and the actual execution plan (sqlplan).
May 15, 2011 at 7:14 am
paste the actual or execution plan of that query
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
May 16, 2011 at 7:07 am
We cannot help you without more details.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply