Difference between Cluster and Non-cluster index?
- 32 Answers
- 138281 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / p.karthick
clustered index is physically stored
a table can have 1 clustered index
non clustered index is logically stored
a table can have 249 non clustred index
| Is This Answer Correct ? | 193 Yes | 46 No |
Post New Answer View All Answers
What is the difference between clustered index and primary key?
Explain the different index configurations a table can have?
Explain alternate key, candidate key and composite key in sql server?
Define full outer join?
How to disconnect from a sql server using mssql_close()?
How to check table values in sql server?
How can you find out how many rows returned in a cursor?
What is the maximum rows in sql server table?
What is the impact on other user sessions when creating indexes?
What is sql or structured query language?
What are the different types of backups avaialabe in sql server 2005?
What does executeupdate return?
Can two tables share the same primary key?
What is the most common trace flags used with sql server?
what are different types of raid configurations? : Sql server database administration
