Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 147139 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / jagan
Clustered Index:- It reorder the table phyically and stores
data in a DATA PAGE. DATA PAGE is nothing but page contains
all the data in correct order.Indexing is known as index in
a book(titles with page number).It helps the SQL SERVER to
retrive the data quickly and make the query to perform
fastly.Only 1 index for a table.
Non Clustered Index:- Index that is created in any order.
we can create up to 249 in a table.Indexing is known as
index in a book(titles with page number). performance will
be little bit less than the clustered index.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What command would you use to create an index?
Are semicolons required at the end of sql statements in sql server 2005?
What is sql injection and why is it a problem? : sql server security
How sql server executes a statement with nested subqueries?
What is the difference between stored procedure and user defined functions?
Explain about Views?
What authentication modes does sql server support?
What are the different kinds of ssrs reports?
What are the different acid properties?
What are the indexes in sql server?
What do you understand by check constraint in sql server?
What are 3 ways to get a count of the number of records in a table?
User wants only to display only pdf as export option in report manager. How to achieve this?
What is a non clustered primary key?
Can you explain various data region available in ssrs with their use?
