Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 146939 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 transaction isolation levels in sql server?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
What is the tcp/ip port on which sql server runs?
Explain user defined views?
Can I save my report as html, excel or word? : sql server management studio
What is bcp? When does it used?
What are the advantages of using stored procedures?
What is store procedure? How do they work?
How to drop an existing table with "drop table" statements in ms sql server?
What functions can a view be used to performed?
What should be the fill factor for indexes created on tables? : sql server database administration
Why truncate is ddl?
What is the downside of using udf?
Can You Use Data Mining Models In Ssrs?
What is sqlcmd?
