How does MariaDB leverage optimizer enhancements such as Cost-Based Optimization (CBO), Index Condition Pushdown (ICP), and Histogram-Based Statistics to improve query execution efficiency and plan selection accuracy, particularly in the context of large-scale datasets and complex join operations ?