Interested to Buy Any Domain ? << Click Here >> for more details...
What is clustered and non-clustered indexes?
- 4 Answers
- 14061 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
Define SQL and state the differences between SQL and other conventional programming Languages?
How do you write an inner join query?
How are functions and procedures called in PL/SQL?
Can we connect to postgresql using sql developer?
How sql query is executed?
what are the differences between char and nchar? : Sql dba
What is compute?
What is the difference between cluster and non-cluster index?
what is the command line end user interface - mysql? : Sql dba
How to select random rows from a table?
What steps server process has to take to execute an update statement?
Is mariadb nosql?
Is progress software supports to ( pl/sql )?
what are the difference between clustered and a non-clustered index? : Sql dba
how to get a list of all tables in a database? : Sql dba
