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

Explain following error properties?

0 Answers  

What is difference between stored procedure and function?

3 Answers   L&T,

what is IDE,DMV in sql server?

1 Answers   Value Labs,

What is sorting and what is the difference between sorting and clustered indexes?

1 Answers  

Explain what is the function of sql server agent windows service?

0 Answers  




Why do we need normalization?

0 Answers  

Is it possible to create tables in stored procedures using a variable for the table name?

2 Answers  

What are different backups available in sql server?

0 Answers  

whats new about truncate in sql server 2008?

0 Answers   MedSave Healthcare, Serco,

What is temporary stored procedure?

0 Answers  

If we shrink the Databse and Files, how much size is decreased?

1 Answers   TCS,

What is the difference between join and inner join?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories