Difference between Cluster and Non-cluster index?
- 32 Answers
- 141585 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 partition, how will you implement it? : sql server analysis services, ssas
What are the benefits and tasks of object explorer? : sql server management studio
How to get a list of columns in a view using "sys.columns" in ms sql server?
Explain transaction server explicit transaction?
How to implement service broker?
How do you Implement SSIS Packages in your Project?
What is store procedure? How do they work? When do you use?
Do you know what is lock escalation?
Define indexes?
Can you use order by when defining a view?
How to write a query with a right outer join in ms sql server?
Why it is recommended to avoid referencing a floating point column in the where clause?
What are the steps to process a single select statement?
Explain what is the use of custom fields in report?
What is the openxml statement in sql server?
