# Execution Plan Optimization
+ Logical Transformation
+ Cost-Based Optimization
![`smart`](TiDBQueryOptimizationOverview_aa_002_20230912.png)
------------------------------------------------------------------------------
If the SQL statement cannot be transformed into a `Point_Get`, it proceeds to the execution plan optimization stage, consisting of two sub-stages: Logical Transformation and Cost-Based Optimization.

Logical Transformation primarily involves rule-based query transformations.

Cost-Based Optimization is responsible for converting SQL statements into execution plans, which serve as a roadmap for the database to retrieve data. This stage involves making decisions about index usage, selecting the appropriate index type, and determining the most efficient table join algorithm to use.