1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Difference between Cluster and Non-cluster index?

Question Posted / guest

Answers were Sorted based on User's Feedback



Difference between Cluster and Non-cluster index?..

Answer / kenatrivedi

Clustered Index is Clustered Index











Non-cluster Index is Non-cluster

Is This Answer Correct ?    61 Yes 255 No

Difference between Cluster and Non-cluster index?..

Answer / hero

Clustered Index is non-Clustered Index









Clustered Index is Clustered Index











Non-cluster Index is cluster index

Is This Answer Correct ?    24 Yes 244 No

Post New Answer

More SQL Server Interview Questions

What is data integrity? Explain constraints?

1 Answers   Thinksoft,

What is application role in sql server database security? : sql server security

0 Answers  

When would you prefer to have a minimum number of indexes?

0 Answers  

If any stored procedure is encrypted, then can we see its definition in activity monitor?

0 Answers  

What should we do to copy the tables, schema and views from one SQL Server to another?

3 Answers  




what are the limitations of parameters in a storedprocedure

1 Answers  

Is trigger fired implicitely?

2 Answers  

How to how to convert numeric expression data types using the convert() function??

0 Answers  

What is thr feature of change data capture?

0 Answers  

What is sql view?

0 Answers  

how can do you the system monitoring?

1 Answers  

What do you mean by data manipulation language?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories