Difference between Cluster and Non-cluster index?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Why is replication required on the sql server?

770


What is store procedure? When do you use?

688


What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

833


How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

712


Define tool Manage Statistics in SQL Server 2000 query ?

736






How do triggers work?

694


How to recreate an existing index in ms sql server?

714


Tell me what do we need queues in sql service broker?

709


State a few properties of relational databases?

837


What are the different SQL Server Versions you have worked on?

764


What is a scheduled job or what is a scheduled task?

711


How to disconnect from a sql server using mssql_close()?

775


Can primary key be null?

683


Explain the functionalities that views support?

856


What are the commands used in DCL?

713