Difference between Cluster and Non-cluster index?
- 32 Answers
- 141757 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
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
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
Which tcl commands are available on the sql server?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
What are the advantages dts has over bcp?
how many type of indexing in database?
What does truncate do?
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
What are the benefits of normalization?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
What is an entity-relationship diagram (erd)?
What is join and name different type of joins?
Explain a join?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
What is a sql join?
Do you know what are the properties of the relational tables?
