Difference between Cluster and Non-cluster index?
- 32 Answers
- 138536 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / rahul
A) Creating a clustered index on a table re-arranges the data in a sequential manner. while creating clustered index, certain guidelines must be followed. They are:
1) Queries should return a range of values by using operators such as, BETWEEN, > , >= , < and <=.
B) Non-clustered index is created on a table, the data is not physically re-arranged in sequential order.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is simple indexing method?
How many triggers are possible per table?
What are the differences between stored procedure and the dynamic sql?
Where the sql logs gets stored?
What is failover clustering overview?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
Explain steps of normalization?
Define inner join? Explain with an example?
How to manipulate data from one table to another table ?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
What is the new security features added in sql server 2014? : sql server security
Can you explain what is sql server english query?
Why we use functions in sql server?
Give me any three differences between Truncate and Delete.
What are the two modes of authentication in sql server?
