Difference between Cluster and Non-cluster index?
- 32 Answers
- 141514 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
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 is an sql server agent?
what data regions are and what are the different data regions?
Explain index in sql server?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
How do I port a number to sql server?
Give the query of getting last two records from the table in SQL SERVER?
What is statement level trigger?
What is sql injection and why is it a problem? : sql server security
How to delete duplicate rows in sql server?
How do I run a trace in sql server?
What the class forname () does?
List types of tables in SQL Azure?
How to Check if table exists in sql server?
Define outer join in sql server joins?
Explain what is public role in sql server?
