Why this query is SO slow?

As subject:

SELECT id
FROM pbase
WHERE id NOT IN
(SELECT id FROM pbase2);

It takes oven an hour to run.

Thank you
Manuel

P.S. Sorry if my english not good Received on Sun Apr 14 2002 - 17:37:32 CDT