- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 67 Insurance
- 536.8K On-Premises Infrastructure
- 138.5K Analytics Software
- 38.6K Application Development Software
- 5.9K Cloud Platform
- 109.5K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
enhance ATTRIBUTE CLUSTERING to do "quick & dirty" work
Attribute Clustering requires a sort of the rows before they are stored to disk.
If the rows does not match into PGA, the Sort must be done using TEMP. This can increase the time needed for INSERT dramatically.
To mitigate this effect, I suggest to allow a quick&dirty ATTRIBUTE CLUSTERING: whenever the Sort Area in PGA is totally used, save those rows to disk.
This will lead to sorted sub-chunks on disk, all of the max PGA size.
Even the data will not be that perfect ordered, it can be a reasonable trade-off between un-sorted inserts and slow (dribven by TEMP-Sort) inserts?
This database idea has been accepted and raised as: ENH 27131584 - ENHANCE ATTRIBUTE CLUSTERING TO DO "QUICK & DIRTY" WORK