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
Is sql server 2016 free?
How you can get a list of all the table constraints in a database?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
What is parameterized reports in ssrs ?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
What is the xml datatype?
What is the difference between inner join and equi join?
How to create database with physical files specified in ms sql server?
what is the difference between Tabular and Matrix report?
Can foreign key be duplicate?
How are the unique and primary key constraints different?
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?
What is constraints and its types?
What are sql server procedures?
What are the tables in sql?