[ASTERIXDB-3093] CBO enhancements and fixes after calibration tests

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Done
• Component/s: *DB - AsterixDB
• Labels: CBO
• Assignee: Vijay Sarathy
• Reporter: Vijay Sarathy
• Created: 05/Dec/22 20:03
• Updated: 30/Jan/23 03:26
• Resolved: 06/Dec/22 17:17

Description

This issue is created to fix any CBO issues that arise after the scan and join calibration tests are run.

The following issues were fixed:

1. Cost based optimization of scans. Prior to this, only queries with (inner) joins were considered for cost based optimization.
2. Fixed bug in printing of join costs in the explain plan. 

Issue Links

• links to: CBO enhancements and fixes after calibration tests.