Difference between Cluster and Non-cluster index?
- 32 Answers
- 140178 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / chandu
Clustered index:
A Table have only one clustered index.
Once we defined a column with primary key constraint, sql
server automatically creates unique clustered index on that
column,
Actual rows arranged in same order as index.
Eg: Dictionary.
Non-clustered index:
Atable have 249 non clustered index.
Once we defined a column with unique key constrain , sql
server automatically create non clustered index.
Actual rows not arranged in same order as index.
Eg: Text book
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
What is the synonym of join?
What is a View ? Can we insert, Update and delete a view?
How to recover from sql injection? : sql server security
What is the use of toad or sqldbx.?
What is the difference between varchar and varchar(max) datatypes?
How can we delete a table in sql server?
What is tabulation?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
Explain syntax for disabling triggers?
What are the different types of triggers in SQL SERVER?
Write a sql query to display the current date?
What are the High-Availability solutions in SQL Server and differentiate them briefly?
How to concatenate two binary strings together?
Explain what are the different index configurations a table can have?
What is query optimization process?
