Partial indexes: indexing selected rows
use-the-index-luke.com
Saved by Franco Passeggi
Partial indexes: indexing selected rows
Saved by Franco Passeggi
one reason to do partial indexes is to avoid the storage cost that comes with craeting indexes.
we avoid storing the records we’re not interested in searching