Interested to Buy Any Domain ? << Click Here >> for more details...
What is clustered and non-clustered indexes?
- 4 Answers
- 14093 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 foreign key? : Sql dba
What is a boolean in sql?
How to run sql*plus commands in sql developer?
Define the select into statement.
What is sql used for?
What is the maximum number of rows in sql table?
What are the types of subqueries?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
How do I filter in sql profiler?
What are functions in sql?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
What is the difference between truncate and drop statements?
What are the two types of cursors in pl sql?
What is a full join?
What is the difference between alter trigger and drop trigger statements?
