Difference between Cluster and Non-cluster index?
- 32 Answers
- 138533 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / veerreddy
clustered index is that the order of data in table is always
equal or matches to order of data stored in index.there is
only one(1) clustered index for table.it is usually applied
on primary key column in table.
other hand the non-clustered index is that the order of data
in table is not equal or matches to order of data stored in
index.so they can be applied on non-primary key columns like
unique,foreign key etc.A table can have (249) non-clustered
indexes
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Difference between DELETE and TRUNCATE?
What is mscorsvw.exe - process - microsoft .net framework ngen?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
State the difference between union and union all?
can we have a nested transaction? : Sql server database administration
how to do partition in sqlserver
What is log ldf?
How to make remote connection in database?
Can select statements be used on views in ms sql server?
How to define and use table alias names in ms sql server?
What is the use of nvl work?
What happens if null values are involved in boolean operations?
How do you implement session management in SQL Server mode?
How to change the ownership of a schema in ms sql server?
Explain mixed authentication mode of sql server?
