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
I am loser -- I didn't realize there was analyze option on vacuum -- I
created another index on Publisher code -- Now it smokes
thanks
Mark Summers
"Stephan Szabo" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
> On Fri,
Currently I am running 6.5.3 should I upgrade to 7.0.3 -- Any advantages or
should I wait
Maybe I should post this somewhere else but I thought I would ask here first
Thanks in advance
Mark Summers
