What is clustered and non-clustered indexes?
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
Explain polymorphism in pl/sql.
Which kind of parameters cannot have a default value in pl sql?
What is integrity in sql?
What is an alias command?
what is offset-fetch filter in tsql? : Transact sql
Can dml statements be used in pl/sql?
What are the types of operators available in sql?
Why do we use triggers?
What are the parameter modes supported by pl/sql?
what is a view? : Sql dba
what is error ora-03113: end-of-file on communication channel?
What is application trigger?
how many tables will create when we create table, what are they? : Sql dba
What is the difference between a subquery and a join?
Is it possible to read/write files to-and-from PL/SQL?