hi

Question

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?

adavce tanks.

Answer 1

Pls check this thread http://www.devtoolshed.com/content/clustered-index-vs-non-clustered-index-sql-server

---

http://uk.linkedin.com/in/ramjaddu

Answer 2

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:

http://aboutsqlserver.com/2010/11/17/primary-key-and-clustered-index/

anyway following are the article which explain you the index from scratch to end in nut shell.

http://www.simple-talk.com/sql/database-administration/brads-sure-guide-to-indexes/

http://www.sqlmag.com/article/sql-server-analysis-services/indexing-the-data-warehouse-

 

thanks,

Zaim Raza.