Difference between Cluster and Non-cluster index?

Answer Posted / ajay kumar gupta

CLUSTERED INDEX:
Clustered index will be created by default when u
create primary key on a column. So we can create one
clustered index per table. clustered index is stored in
serial passion.

NON CLUSTERED INDEX:
Non clustered index will be created automatically when u
create unique key on a column. A table can have no.of
unique keys, so we can create no.of non clustered indexes
per table.

Is This Answer Correct ?    141 Yes 37 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is sql server 2016 free?

734


How you can get a list of all the table constraints in a database?

740


You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

739


What is parameterized reports in ssrs ?

127


what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

766


What is the xml datatype?

845


What is the difference between inner join and equi join?

746


How to create database with physical files specified in ms sql server?

785


what is the difference between Tabular and Matrix report?

146


Can foreign key be duplicate?

843


How are the unique and primary key constraints different?

830


You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

780


What is constraints and its types?

726


What are sql server procedures?

777


What are the tables in sql?

836