| 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
| 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) |