| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | "Mark A(dot) Summers" <msummers(at)irtnet(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: SQL Help |
| Date: | 2001-01-27 01:48:07 |
| Message-ID: | Pine.BSF.4.21.0101261746560.98620-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Fri, 26 Jan 2001, Mark A. Summers wrote:
> I am having trouble with the following query taking forever:
> -----
> SELECT * FROM ret108108_00, product
> WHERE ret108108_00."isbn" = product."Item1"
>
> AND product."SuperCategory" = '1'
> AND product."PublisherCode" = 'ZON'
> ORDER BY ret108108_00.qty DESC LIMIT 100
> ----
> The problem is the second AND -- if I take this out it runs fine -- is there
> any way to optimize it ? I had a similar problem with just Category so I
> created a new field in the product file called FullCat which combined
> SuperCategory and Category and thus eliminating the 2nd AND clause -- and
> that fixed it -- I just didn't want to do the same thing with Publisher.
> Before I tried to index Category, SuperCategory ... nothing seemed to help
Have you run a VACUUM ANALYZE on the table? And what does
EXPLAIN show for the query?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kovacs Baldvin | 2001-01-27 02:07:41 | Architectural question |
| Previous Message | Colin Faber | 2001-01-27 01:24:58 | Re: #DELETED error when using Access 2000 as frontend |