Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 147091 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
explain extended properties
Can you always create a cache of a report?
What is the maximum length of an alert name?
How to update values in a table with update statements in ms sql server?
What is sql server database?
Detail about the hardware which is supported by SQL server?
How do triggers work?
How to Sync Two SQL Azure Databases?
What is a partition key?
How to insert and update data into a table with "insert" and "update" statements?
How to replace given values with null using nullif()?
Can we insert data into a view?
What are trace flags?
Do you know how to implement service broker?
What are the types of lock supported by ?
