At 2006-11-10 01:15:24 -0500, [EMAIL PROTECTED] wrote:
>
> it seems that "field<=12" is true for a much smaller fraction of the
> rows satisfying (part!='' or value ilike '%,%') than for the general
> population of rows in the header_fields table.
Indeed. One-sixth of the rows in the entire table
Abhijit Menon-Sen <[EMAIL PROTECTED]> writes:
> The header_fields table contains 13.5M rows, of which only ~250K match
> the where condition. I created an index like this:
> create index hffpv on header_fields(field)
> where field<=12 and (part!='' or value ilike '%,%')
> Note the 2M estim
