# Sql Tuning Principles (B)

+ Use appropriate indexes for retrieval and sort, try to avoid full table scan, sort and manipulating large amounts of data
  + Indexes need to be highly selective
  + Considering the frequency of index usage and index cost
  + column that are updated frequently are not suitable for indexing

------------------------------------------------------------

[no notes]