Are indexes that were created for a table also clustered automatically if the table has the cluster attribute?
If a table receives the cluster attribute, only new indexes on the table also receive the cluster attribute. Existing indexes do not receive the cluster attribute automatically. You must delete and recreate the affected indexes to ensure that index data is also stored in clusters.11. What happens when I execute the ALTER TABLE CLUSTER statement for a table? In the database catalog (system table FILES), the relevant table receives the cluster table attribute. At this point, the system reads all of the table data into the cache and stores it in segments on the data volumes at the next save point. Remark: The runtime of the alter table cluster command depends on the size of the table. As long as the alter table command is active, the table is locked for all accesses from the application in the available MaxDB versions (PTS:1174872 and PTS:1174879).
Related Questions
- What are the Best Practices for using a clustered file system with Oracle RAC? Can I use a cluster file system for OCR, Voting Disk, Binaries as well as database files?
- I don want Heartbeat to fail over the cluster automatically. How can I require human confirmation before failing over?
- CLUSTERED TABLE EXISTS?
