Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 147229 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
How to count rows with the count(*) function in ms sql server?
What is RMS migrations?
What are the different types of Indexes available in SQL Server?
Write a query to find 5th highest amount paid from the customer table.
What is lock escalation and what is its purpose?
What is scalar user-defined function?
Explain triggers?
What is BCNF? How is it better than 2NF & 3NF?
What is a trigger? Why we need it?
Mention the different types of replication in sql server.
What is transaction server explicit transaction?
How to implement service broker?
When cursors are useful?
When would you use sql joins?
How to create percentile function?
