Difference between Cluster and Non-cluster index?
Answer Posted / yashpal
Clustered index will be created by default when u
create primary key on a column. only one clustered index is
created per table
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 ? | 1 Yes | 0 No |
Post New Answer View All Answers
Do comments need to go in a special place in sql server 2005?
Explain what is the function of sql server agent windows service?
What to check if a User database is locked?
Can we call future method from queueable?
What is indexed view?
Delete duplicate rows without using rowid.
How do I view a procedure in sql server?
Tell me can we use custom code in ssrs?
Tell me what is difference between view and materialized view?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
Which data type columns are the best candidates for full-text indexing?
What do you mean by table and field in sql?
What do we have to check in database testing?
What is a schema in ms sql server 2005?