Partial indexes: indexing selected rows
use-the-index-luke.com
Saved by Franco Passeggi
Partial indexes: indexing selected rows
Due to the logarithmic scalability the index nevertheless makes the query very fast even though it wastes a lot of disk space.
Partial indexes: indexing selected rows
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