Details
-
Task
-
Resolution: Unresolved
-
Test Blocker
-
7.2.0
-
0
-
Analytics CBO Sprint 14, Analytics CBO Sprint 15, Analytics CBO Sprint 16, Analytics CBO Sprint 17, Analytics CBO Sprint 18, Analytics CBO Sprint 19, Analytics CBO Sprint 20, Analytics CBO Sprint 21, Analytics Sprint 24, Analytics Sprint 25, Analytics Sprint 26, Analytics Sprint 27, Analytics Sprint 28, Analytics Sprint 29, Analytics Sprint 30, Analytics Sprint 31, Analytics Sprint 32, Analytics Sprint 33, Analytics Sprint 34, Analytics Sprint 35, Analytics Sprint 36, Analytics Sprint 37, Analytics Sprint 38, Analytics Sprint 39
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.