Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 146995 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
How can you ensure that the database and sql server based application perform well?
Tell me what is normalization? Explain different forms of normalization?
What is store procedure?
Can a cursor be updated? If yes, how you can protect which columns are updated?
What is the difference between a check constraint and a rule?
What is difference between equi join and inner join?
How do database indexes work?
What is the report model project?
What is collation sensitivity?
Do you know what guidelines should be followed to help minimize deadlocks?
What is the correct order of the logical query processing phases?
How to delete database objects with "drop" statements in ms sql server?
How do I find sql server instance name?
Does table partitioning improve performance?
What do you understand by check constraint in sql server?
