Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 145962 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
Do you know what is difference between index seek vs. Index scan?
What are dml triggers and types of dml triggers?
How to define the name and server for a new dsn?
What is an indexing strategy?
What are the grouping functions?
What happens if ntwdblib.dll is missing on your machine?
What is the default server name for sql server?
What is the difference between stored procedure and user defined functions?
Explain some stored procedure creating best practices or guidelines?
What is application role in sql server database security? : sql server security
What is normalization of database?
what is difference between view and Dip.
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
What do you mean by an execution plan?
