What is clustered and non-clustered indexes?
- 4 Answers
- 12560 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 using in sql?
Explain the purpose of %type and %rowtype data types with the example?
Is trigger a stored procedure?
What are pl/sql cursors?
what is a trigger in mysql? : Sql dba
what is the different between now() and current_date()? : Sql dba
What is on delete restrict?
What is sql not null constraint?
Which one is better sql or oracle?
Can you load data into multiple tables at once? : aql loader
Is join same as left join?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
What is user defined functions?
How show all rows in sql?
What is recursive stored procedure?
