Interested to Buy Any Domain ? << Click Here >> for more details...
What is clustered and non-clustered indexes?
- 4 Answers
- 13890 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / shubhi
There are clustered and nonclustered indexes. A clustered
index is a special type of index that reorders the way
records in the table are physically stored. Therefore table
can have only one clustered index. The leaf nodes of a
clustered index contain the data pages.
A nonclustered index is a special type of index in which
the logical order of the index does not match the physical
stored order of the rows on disk. The leaf node of a
nonclustered index does not consist of the data pages.
Instead, the leaf nodes contain index rows.
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
What is difference between cursor and trigger?
discuss about myisam key cache. : Sql dba
What is an emotional trigger?
Write a sql select query that only returns each name only once from a table?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What is time based sql injection?
What is a rank in sql?
What are the dml statements?
What does data normalization mean?
how can we submit a form without a submit button? : Sql dba
Is merge a dml statement?
Mention what are the benefits of pl/sql packages?
explain access control lists. : Sql dba
Why do we create stored procedures & functions in pl/sql and how are they different?
Which constraints we can use while creating database in sql?
