What is clustered and non-clustered indexes?
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 are three advantages to using sql?
How do you sort in sql?
give the syntax of grant and revoke commands? : Sql dba
What are the possible values for the boolean data field?
how to return query output in html format? : Sql dba
What is blind sql injection?
What is exit statement?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
What is a join query?
Give the order of sql select?
Are dml statements autocommit?
What is trigger in pl sql?
What plvcmt and plvrb does in pl/sql?
Explain what is a view?
Why is %isopen always false for an implicit cursor?