Thread: SELECT .. WHERE field IN (SELECT .. )

SELECT .. WHERE field IN (SELECT .. )

From

Predrag Lesic

Date:

27 July 1999, 12:39:18

I have problem with next query

SELECT COUNT(*) FROM TABLE1 WHERE field1 IN (SELECT DISTINCT field2
FROM TABLE2 WHERE field3>'some date')

Processing time of the query is toooooooooo long. I didn't get the
answer. Postgres is doing something, I can see disk is working for some
time, and the query is running. But how long?????

Thank's
Predrag