# Indexing for Query Performance
+ A good indexing strategy enables TiDB reduces I/O by
  + Avoiding full table scans
  + Avoiding sorting
  + Skipping row lookups when possible
------------------------------------------------------------------------------
Indexing is the most crucial strategy for optimizing query performance. Sorting data rows in the table itself provides only a single perspective or `VIEW` of the table. In contrast, indexes allow for multiple perspectives. The TiDB optimizer uses indexes to quickly match rows and filter out irrelevant results, avoiding the need for a full table scan.