How to use covering index to improve performance ensure index covers the columns to be sorted too (in asc/desc), e.g. create index on users (id, created_at desc) TODO: Any sample query, and how to find if there are performance difference TODO: what are covering index tricks that we can use