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
Which are new data types introduced in sql server 2008?
Do you know the different ddl commands in sql?
What are the requirements on sql server network connections?
What is the difference between value type and reference type?
List out the difference between union and union all in sql server?
How to modify an existing stored procedure in ms sql server?
what is a sub-report?
How to find table changes in sql server?
How is sql server used?
What is difference between global temporary tables and local temporary tables?
Do you know the cursor types?
Explain about system database?
What is the maximum size per database for sql server express?
What is user-defined function?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?