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
what are the new features in SSRS?
What are pessimistic lock and optimistic lock?
What is a cache in ssrs?
Difference between aggregate functions of sql?
how to determine the service pack currently installed on sql server? : Sql server database administration
what are acid properties? : Sql server database administration
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
Are connections to sql server encrypted?
What are the different types of stored procedures?
what's the maximum size of a row? : Sql server database administration
Would you store your query in a ssrs report or a database server? State the reason why?
What happens if ntwdblib.dll is missing on your machine?
What is sql server locking?
What are the requirements on sql server network connections?
List out a number of the wants to setup a SQL Server failover cluster?