Difference between Cluster and Non-cluster index?
Answer Posted / suvek samyal
>clustered index store the actual data.
>one table can only have one clustered index because
clustered index is the actual table stored in order of the
clustered key.
>usually primary key used as the clusted key,but we can
also take the combinition of first name and last name as a
clustered key.
>printing phone directory is the best example of clustered
index.
-->non-clustered index is just like a pointer to the data.
-->one table can have upto 249 non-clustered indexs because
it has the pointer of actual row.
-->page no.,google search and other search engines used as
a pointer of non-clustered index.
-->the index in the back of a book is the best example of
non-clustered index
Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
Define a cross join?
Explain important index characteristics?
How to download microsoft sql server 2005 express edition?
What is row_number()?
Explain what are the database objects? : SQL Server Architecture
What is server-level principal?
How you can get the list of largest tables in a database?
Explain “@@rowcount” and “@@error” in sql server?
How sql server executes a statement with nested subqueries?
What is the new security features added in sql server 2014? : sql server security
What are the five major components of a dbms?
What is a Join and explain its types?
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
Explain few of the new features of sql server 2008 management studio
What is raiseerror? What is raiseerror?