×
Optimizer

Insights into the Selection of PolarDB XPlan Indexes

This article introduces a local index algorithm on CN: XPlan index selection.

PolarDB-X Optimizer Core Technology: Execution Plan Management

This article discusses the importance of SQL Plan Management in maintaining stable database performance by optimizing the execution plan and managing multiple plans for a single SQL query.

Are You Using the MySQL Index Correctly?

This article starts with the problems encountered and analyzes the TDDL optimizer, the MySQL index, and the selection of shard keys for table partitioning.

About Database Kernel | PolarDB Optimizer Query Transformation - Join Condition Pushdown

This article introduces the concept of join condition pushdown of query transformation in database optimization.

About Database Kernel | PolarDB Optimizer Query Transformation - Join Elimination

This article describes a heuristic query transformation implemented by PolarDB called join elimination.

About Database Kernel | PolarDB Optimizer Query Transformation - Window Functions

This article introduces a method that utilizes the capabilities of window aggregate functions to decorrelate subqueries.

Solving Task Assignment Problems (Getting Started with Mindopt)

This article discusses MindOpt APL (MAPL) and how MindOpt Solver supports solving linear programming (LP) problems.

Details of the Architecture of MySQL 8.0 Server Layer

This article analyzes and summarizes the source code of MySQL 8.0.25.