Difference between Cluster and Non-cluster index?
Answer Posted / upma
when u create primary key in a table than cluster index are automatically created...becoz there can b only one primary key on a table,so cluster index is one in a table.cluster index reorder the way records in a table are physically stored...
Non cluster index,when u create unique automatically generated... 249 non cluster index in a table,because we can apply more than one unique key in a table..
logically order, does not match with physical order..
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what are acid properties? : Sql server database administration
Explain what is lock escalation?
What happens if the update subquery returns multiple rows in ms sql server?
How to declare a cursor with "declare ... Cursor" in ms sql server?
What it means to be triggered?
What is equi join with example?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
Why are views required in the sql server or in any other database?
Explain cdc and sql injection?
Explain transaction server auto commit?
What is difference between unique and primary key?
What is the default sql server instance name?
How global temporary tables are represented and its scope?
What is service broker? : sql server database administration
How to enter unicode character string literals in ms sql server?