Rajesh Kumar Mallah wrote:
Hi,
NOT EXISTS is taking almost double time than NOT IN .
I know IN has been optimised in 7.4 but is anything
wrong with the NOT EXISTS?
I have vaccumed , analyze and run the query many times
still not in is faster than exists :
Seems fine. In 7.4, NOT IN
Robert Treat wrote:
It is believed that the IN optimization can lead to faster IN times than
EXIST times on some queries, the extent of which is still a bit of an
unknown. (Incidentally is there an FAQ item on this that needs
updating?)
Thanks every one for clarifying. Its really a
It is believed that the IN optimization can lead to faster IN times than
EXIST times on some queries, the extent of which is still a bit of an
unknown. (Incidentally is there an FAQ item on this that needs
updating?)
Does the not exist query produce worse results in 7.4 than it did in
7.3?
Robert Treat [EMAIL PROTECTED] writes:
Does the not exist query produce worse results in 7.4 than it did in
7.3?
EXISTS should work the same as before.
regards, tom lane
---(end of broadcast)---
TIP 5: Have you checked
On Thu, 2003-11-13 at 12:00, Tom Lane wrote:
Robert Treat [EMAIL PROTECTED] writes:
Does the not exist query produce worse results in 7.4 than it did in
7.3?
EXISTS should work the same as before.
right. the original poster is asking if there is something wrong with
exist based on the