Parallel query avoidance (Oracle)
Oracle parallel query is generally used for data warehousing
applications and is not appropriate for Content Platform Engine. Oracle parallel query
can cause query execution plans to use table scans instead of the
expected database indexes.
Property skew resolution
Address the problem of skew by proper design of the application
or with the necessary database-specific solutions.
Periodic Reorg (DB2)
On DB2®, a table REORG can
make a query faster when feasible to run.