Details
-
Task
-
Status: Open
-
Test Blocker
-
Resolution: Unresolved
-
7.2.0
Description
There are many ways to improve query plans using hints. However we'd need to make sure that an un-hinted version of a query performs reasonably well.
To confirm that CBO plans are reasonable with and without hints we should compare runs of the CH2 queries with and without hints (at a DGM scale).
- Run an RBO version for each query (manually structured query to optimize performance).
- Run the original CH2 query.
- Run without skip-index hints.