# Split Read Hotspot (C)

+ The SQL execution plan is unreasonable
  + Missing indexes, unnecessary full table scan
  + Multiple indexes, but the optimizer chose the wrong one
    + Check the health of the goal table statistics
    + Intervention optimizer
------------------------------------------------------------
    - Missing indexes, unnecessary full table scan: add appropriate indexes based on business access characteristics
    - Multiple indexes, but the optimizer chooses wrong
      - Check the health of goal table statistics, collect goal table statistics manually
      - Confirm the optimal index and use SQL binding to intervene in the optimizer to select the correct SQL without changing the SQL