-
Type:
Task
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Optimization
-
None
-
None
-
None
-
None
-
None
-
None
-
None
SERVER-134637 is adding support for CE & costing of wildcard/hashed/collated index scans in CBR. That means that automatically these indexes can also be used for single table access plans in JOO. The problem is that our code costIndexScanFragment() is not prepared to cost I/O for any indexes beside BTrees. The options we have:
- Modify costing of IXSCAN fragment and give some cost for unknown index types (con: may be wrong)
- Use existing IXSCAN fragment IO cost for BTree and use same logic for all index types (con: may be extra wrong, but lowest effort)
- Bail at JOO level if there’s a non-BTree index (con: any query on a collection with a wildcard index would bail)
- Pass in a filtered set of indexes to single table plan enumerator for single table access paths (i.e. what we do for index probe access path planning)- con: CBR on the same query gives users a different plan, could be a usability problem (Peter Volk
suggested it would be here)
In any case we should do SERVER-133702.