Difference between Cluster and Non-cluster index?
- 32 Answers
- 141544 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / naren
clustered index is created on actual data.
Non clustered index ix created on pointer of data.
If there is primary key by default clustered index is
created.
else non clustered index created.
only one clustered index is possible to create.
249 non clustered indexex can be created.
| Is This Answer Correct ? | 59 Yes | 15 No |
Post New Answer View All Answers
Ways to improve the performance of a SQL Azure Database?
What do you understand by a stored procedure?
What are the types of lock supported by ?
How will you hide an attribute? : sql server analysis services, ssas
How you can change the database name in SQL SERVER?
What is equi join with example?
What is difference statement and preparedstatement?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
What is apply operator in sql?
How to find the list of fixed hard drive and free space on server?
What are the different kinds of ssrs reports?
How to turn on the mssql api module in php?
Explain linked server in sql?
what's the maximum size of a row? : Sql server database administration
How to bind a view to the schema of the underlying tables?
