We've a table with about 8 million rows, and we need to get rows by the value of two of itsfields( the typeof thefieldsare int2 and int4, the where condition is v.g. partido=99 and partida=123). We created a multicolumn index on that fieldsbut the planner doesn't use it, it still use a seqscan.
Adrian Demaestri wrote:
We've a table with about 8 million rows, and we need to get rows by the value
of two of its fields( the type of the fields are int2 and int4,
the where condition is v.g. partido=99 and partida=123). We created a
multicolumn index on that fields but the planner doesn't use
On Wed, 8 Oct 2003 09:08:59 -0500 (CDT), Adrian Demaestri
[EMAIL PROTECTED] wrote:
the type of the fields are int2 and
int4, the where condition is v.g. partido=99 and partida=123).
Write your search condition as
WHERE partido=99::int2 and partida=123
Servus
Manfred