Friday, February 03, 2012 4:38 AM
I have a table like sales, the columns in that table are like saleid,item......... like that
on saleid column already i have primary key, by default clustured index come on that column. My question is in some cases we drop the clustrued index on that column & again recreate the non clustured index.
what are the situation when we go for that one?
please expalin as soon as possible?
it's really helpful to me?
Friday, February 03, 2012 10:18 AMPls check this thread http://www.devtoolshed.com/content/clustered-index-vs-non-clustered-index-sql-server
Monday, February 06, 2012 5:40 AM
the use of clustered vs non clustered index depends upon the requirements and type of database operation you are mostly perform on the underline table.
few factors we need to adhere when choosing type of index(clustered/ non clustered index) i.e. storage, purpose(database operations)....
following are the list of factors:
anyway following are the article which explain you the index from scratch to end in nut shell.