Hello,
I am trying out a few databases to determine which one would best suit a
project.
I was wondering if someone could answer a question about how PostgreSQL uses
indexes when performing queries. Particularly, I need to know if the query
optimizer will use more than index for a query or if it only uses one.
For instance, one of my tables (1 million records) contains a document
number, a document type, a received date, a review date, an entered date,
and an audited date.
If I want to retrieve the following pieces of data:
all of the documents of type 1 that were received yesterday
all of the documents of type 2 that were entered yesterday
all of the documents of type 2 that were reviewed yesterday
Would I be able to create individual indexes on type, received date, entered
date, and reviewed date and the optimizer would select the appropriate two
indexes, or would I have to create three composite indexes that would
include type-received, type-entered, and type-reviewed?
Thanks for the help.
Darrell