Difference between Cluster and Non-cluster index?
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
How to update muliple row in single query?
what is isolation level at dead lock?
Create and insert into temp table in sql server?
What are dml triggers and types of dml triggers?
Do you know what are acid properties?
Explain external key management in sql server 2008
Where is localdb stored?
What is difference between inner join and join?
What is acid mean in sql server?
How to check parameter value in stored procedure sql server?
What is temporary stored procedure?
What is the difference between for xml raw and for xml auto?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
What is table valued function and scalar valued functions?
What is database dimension? : sql server analysis services, ssas