Interested to Buy Any Domain ? << Click Here >> for more details...
What is clustered and non-clustered indexes?
- 4 Answers
- 14216 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
How to run pl sql program in mysql?
what are dynamic queries in t-sql? : Transact sql
Is full outer join same as cross join?
Which constraints we can use while creating database in sql?
Who is the owner of mysql database?
Why query optimization is needed?
What is rownum?
what is a trigger in mysql? : Sql dba
How to pipe multiline string to isql?
Is sql an operating system?
Can we insert in sql function?
What is the basic structure of an sql?
How to connect a sql*plus session to an oracle server?
what is the bond code in materialized view?
Why do we need view in sql?
