Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 146962 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
Explain about thread and memory management process of SQL?
When would you use the stored procedures or functions?
How to view the error log for any specific instance? : sql server database administration
What are the different type of replication in sql server?
What command is used to create a database in the sql server and how?
What is the boxing and unboxing concept in .net?
How to rebuild indexes with alter index ... Rebuild?
Tell me what is difference between clustered and non clustered index?
Describe in brief authentication modes in sql server.
How to name query output columns in ms sql server?
What is order of B+tree?
How many servers can we create in a single subscription?
Explain what is it unwise to create wide clustered index keys?
Why is replication required on the sql server?
What is simple indexing method?
