Is there any way to specify an index for PostgreSQL to use for a
particular query? My application has to execute a lot of queries like
this : select count(*) from MyTable where IndexedField_1 = value_1 and
IndexedField_2 = value_2 and ... IndexedField_n = value_n
Sometimes Query Planner decides not to use any of the indexes, but that
I can handle by setting enable_seqscan to off.
What's worse is that sometimes a wrong index is used. I know exactly
which index is the best one, because by the time I execute the query I
already have results of all the primitive queries of this kind : select
count(*) from MyTable where IndexedField_i = value_i; (i = 1..n)
Can I somehow let the Query Planner know about it ?
I am pretty sure I can't do this with 7.0.2 , but what about 7.1 ??
Thanks a lot,
Dmitriy Agafonov.