Interested to Buy Any Domain ? << Click Here >> for more details...
What is clustered and non-clustered indexes?
- 4 Answers
- 14038 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 compute?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
describe transaction-safe table types in mysql : sql dba
Why join is faster than subquery?
What is the use of procedures?
What does subquery mean in sql?
Is sql easier than java?
What is constant in pl sql?
Why stored procedure is better than query?
Can we rename a column in the output of sql query?
What is full join in sql?
where are cookies actually stored on the hard disk? : Sql dba
What is an intersect?
What is pl sql record in oracle?
What do you mean by stored procedures?
