Uncorrelated query performance checker

Bug #645949 reported by Philip Stoev
6
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_PERFORMANCE_INFERIOR tag that will mark the Transform as failed if the transformed, inlined query took substantially longer than the original query.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.