# SQL Tuning Strategy - Reducing the Required I/O
+ Minimize the number of columns in the **`SELECT`** statement
+ Use a **`WHERE`** clause to filter irrelevant results
+ Use a **`LIMIT`** clause to minimize the size of the result set
+ Carefully create indexes on relevant columns for fast lookup
+ Push down predicates and functions to TiKV layer when possible
+ Create indexes that can hold all required data for small, frequent queries to enable **`IndexReader`**
------------------------------------------------------------------------------
These strategies are detailed in the following slides.