Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 148198 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
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
What are views in ms sql server?
what are the new features introduced in sql server 2000? : Sql server database administration
explain what is raid and what are different types of raid configurations? : Sql server database administration
What is the correct order of the logical query processing phases?
How are the exceptions handled in sql server programming?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
How to use wildcard characters in like operations in ms sql server?
Are resultset updatable?
Explain syntax for disabling triggers?
What stored by the model? : sql server database administration
What are the advantages of passing name-value pairs as parameters?
What is linked report?
How to delete database objects with "drop" statements in ms sql server?
What is Replication?
