What is Index Cluster ?

Answer Posted / nishi

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

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is proxy method?

540


What is the difference between a hot backup and a cold backup in oracle?

573


How to upsert (update or insert into a table)?

537


11. Display the client number and name and the client number and name of the person who referred that client.

1920


How to create id with auto_increment on oracle?

545






What is a synonym? What are its various types?

622


How to shutdown your 10g xe server?

618


A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

4257


What is the difference between online and offline backups?

560


What is ADDM Advisor in Oracle?

659


What is the difference between 10g OEM and 11g OEM?

561


What is system global area (sga) in oracle?

571


How to get a create statement for an existing table?

572


How do you find current date and time in oracle?

588


How to fetch the row which has the max value for a column?

538