Difference between Cluster and Non-cluster index?

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

Is it possible to update the views? If yes, how, if not, why?

0 Answers  


What are system databases in ms sql server?

0 Answers  


Explain what are page splits? : SQL Server Architecture

0 Answers  


Write a sql query to sort on different column name according to the parameters passed in the function?

0 Answers  


What is tempdb database? : SQL Server Architecture

0 Answers  






What is truncate table?

0 Answers  


Can you explain what is sql server english query?

0 Answers  


What is difference between views and tables?

0 Answers  


can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?

1 Answers  


How extra digits are handled with numeric data type literals?

0 Answers  


What is transact-sql language?

0 Answers  


How do I perform an unattended install of sql server 2000?

0 Answers  


Categories