-
Type: Improvement
-
Resolution: Unresolved
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
Query Optimization
Most of this code is for the Bonsai optimizer, which is now unused and untested. We should simplify the code base by deleting it. Note that there are some pieces that need to be moved elsewhere and preserved – this includes at least the PolyValue and ABT code, since I believe some of this is used by the SBE stage builders.
Note that related ticket SERVER-92832 proposes creating a db/query/planner/ directory which is where the majority of the QO code is expected to live.
- depends on
-
SERVER-93619 Remove SBENodeLowering dependencies on optimizer Metadata
- Closed
- is depended on by
-
SERVER-93542 Move query_sbe_abt library to stage_builders/ directory
- Needs Scheduling
- is related to
-
SERVER-92832 Create db/query/planner subdirectory
- Open
-
SERVER-93826 Remove SBE ABT lowering dependency on Logical/Physical Props
- Closed
-
SERVER-95472 Remove unused pipeline/abt libraries
- Closed
-
SERVER-96079 Rename bonsai_query_bm_fixture to avoid mentioning bonsai
- Closed
- related to
-
SERVER-93155 Remove entry points into bonsai based plan executor
- Closed
- split to
-
SERVER-93315 Delete src/mongo/db/query/framework_control.cpp
- Blocked
-
SERVER-93164 Remove Bonsai related code from PlanExecutor
- Closed
-
SERVER-93167 Audit tests in query/optimizer/optimizer_test.cpp
- Closed
-
SERVER-93177 Remove Bonsai specific CanonicalQuery plan cache encoding
- Closed
-
SERVER-93183 Delete queryPlannerDebug explain verbosity
- Closed
-
SERVER-93309 Remove references to BonsaiEligibility
- Closed
-
SERVER-93310 Delete jstests/libs/optimizer_utils.js
- Closed
-
SERVER-93311 Delete featureFlagCommonQueryFramework
- Closed
-
SERVER-93366 Delete uses and definition of OptPhaseManager
- Closed
-
SERVER-93368 Delete sbe_abt_test_util library and uses
- Closed
-
SERVER-93663 Delete OptimizerCounterInfo
- Closed
-
SERVER-93664 Delete Cascades/memo-based rewrites
- Closed
-
SERVER-93666 Audit query/ce/ directories for dead code
- Closed
-
SERVER-93687 Delete CQF jstests
- Closed
-
SERVER-93688 Delete Bonsai Cost Model
- Closed
-
SERVER-93807 Delete Metadata and MetadataFactory
- Closed
-
SERVER-93808 Delete SargableNode
- Closed
-
SERVER-93809 Delete LogicalProps and PhysicalProps
- Closed
-
SERVER-93810 Delete MemoLogicalDelegatorNode and MemoPhysicalDelegatorNode
- Closed
-
SERVER-93811 Delete SamplingConstEval
- Closed
-
SERVER-93815 Delete Cascades related query knobs
- Closed
-
SERVER-93828 Delete PartialSchemaRequirements
- Closed
-
SERVER-94899 Delete requires_cqf jstests + golden output
- Closed
-
SERVER-94900 Delete all references to CQF in jstests
- Closed
-
SERVER-95177 Remove MQL to ABT translation
- Closed
-
SERVER-95273 Delete PathLowering
- Closed
-
SERVER-95274 Delete ProjSpecBuilder and rewrites/proj_spec_lower
- Closed
-
SERVER-95275 Remove heuristic optimizer rewrites: (Bonsai) ConstEval, path rewrites, ProjNormalize
- Closed
-
SERVER-95277 Delete NodeLowering
- Closed
-
SERVER-95364 Remove references to feature flag CommonQueryFramework in all_commands* jstests
- Closed
-
SERVER-95416 Remove unused path and interval utils and associated tests
- Closed
-
SERVER-95457 Delete Bonsai index bounds definitions
- Closed
-
SERVER-95459 Remove ABT Nodes and Paths
- Closed
-
SERVER-95464 Delete Bonsai's BoolExpr
- Closed
-
SERVER-95486 Remove ComparisonOpSemantics
- Closed
-
SERVER-96104 Delete Bonsai explain implementation for Nodes, Paths
- Closed
-
SERVER-96123 Delete dead Bonsai explain code
- Closed
-
SERVER-96133 Remove gdb pretty printers for ABT Nodes and Paths
- Closed
-
SERVER-95312 Move remaining Bonsai code used by the stage builders into the stage builders directory and make it owned by QE
- Needs Scheduling
-
SERVER-95512 Move ExpressionConstEval test cases in sbe_abt_test to expression_const_eval_test
- Needs Scheduling