New Optimizer: Improved Cost estimation when large table is involved in a join

Details

Detail name Value
Changelog Number 14169
Type Improvement
Status Open

Improvement

Improved cost estimation in the new optimizer for joins when large tables are involved.
In such scenarios, this results in better join ordering and therefore faster query execution.