Re: RV: bad result in a query!! hopeless - Mailing list pgsql-general

On Wed, 2002-10-16 at 13:36, Jose Antonio Leo wrote:
>
> >You might find a partial index helps a little on the descriptions, but
> >it won,t do much. See the docs on CREATE INDEX .... WHERE
>
> You thinks is better a partial index or a view or both?

The view is just to simplify the query.
Try the partial index on the query table and see if that helps any.

- Richard Huxton