How is clustered index different from non-clustered index?
Answer / Keshav Kumar Jha
In a clustered index, the actual data in a table is physically ordered by the key column(s). A table can only have one clustered index. In contrast, a non-clustered index stores the indexed columns along with a pointer to the location of the corresponding row in the table.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the components required to manage oracle real application clusters database?
What is the load balancing advisory?
Explain the oracle grid infrastructure?
What is a password file in a database and why is it required when a user can be authenticated using data dictionary tables?
Mention how oracle flex asm works?
Why do we need to rebuild indexes?
Mention what is the difference between single instance environment and rac environment?
What is rac and what are the various benefits of using rac architecture?
What are the tools provided in oracle enterprise manager?
How do you recover a lost control file?
Mention what are the tools provided in oracle enterprise manager?
How oracle flex asm works?