Re: RV: bad result in a query!! hopeless

From: Richard Huxton <dev(at)archonet(dot)com>
To: Jose Antonio Leo <jaleo8(at)storelandia(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: RV: bad result in a query!! hopeless
Date: 2002-10-16 15:24:29
Message-ID: 1034781869.13223.18.camel@client.archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Florian Litot 2002-10-16 15:30:30 information
Previous Message Robert Treat 2002-10-16 15:11:22 Re: '-i option' with Runlevel script (RPM version)