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 is the xml datatype?
Explain time data type in sal server 2008?
what is raid? : Sql server database administration
Is foreign key unique?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
How to loop through result set objects using mssql_fetch_array()?
Define self join in sql server joins?
what is blocking? : Sql server database administration
What happens when converting big values to numeric data types?
In which tcp/ip port does sql server run? Can it be changed?
What is a primary key?
What is the partitioning method?
What are binary string data types in ms sql server?
ow to bring suspect mode datbase online from scratch
Is sql server free?