Uncorrelated query performance checker
Bug #645949 reported by
Philip Stoev
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Random Query Generator |
New
|
Undecided
|
Unassigned |
Bug Description
It is possible to test the performance of uncorrelated subqueries by extracting them from the outer query and running them separately.
If the extracted query takes less time to execute v.s. executing the initial query with the subquery values inlined, then the optimizer plan that was chosen was inferior to manually decomposing the query using a higher-level language.
This can be implemented in the InlineSubqueries Validator by introducing a separate TRANSFORM_
To post a comment you must log in.