Description
When CBO considers intersect scan from multiple indexes, it currently always pick an index with either order pushdown or early order. For order pushdown this is ok since we only do order pushdown if index has exact spans (no false positives). For early order we should not always prefer an index with early order, since it is possible that there are additional filters that can filter out results from the index scan, and we could have another more selective index that can be used.
Attachments
Issue Links
For Gerrit Dashboard: MB-57666 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
193247,2 | MB-57666 With CBO do not always pick index scan with order | master | query | Status: MERGED | +2 | +1 |
209792,2 | MB-61842 Allow early order even if limit cannot be pushed to early order | trinity | query | Status: MERGED | +2 | +1 |
209793,2 | MB-61842 Allow early order even if limit cannot be pushed to early order | neo | query | Status: MERGED | +2 | +1 |