Indices in general

use covering index
the order of the index in compound index matters
in postgres, you can allow indexes with includes column
you can also have function based indexing
index can be ordered in ascending and descending