On Wed, Jun 29, 2005 at 09:25:24AM -0400, David Gagnon wrote:
>
> I stop the following statement after 3 minutes....
>
> explain analyse select *
> From IC
> where IC.ICNUM NOT IN (select IRICNUM from IR WHERE IRSTATUT in
> (1, 2))
What does EXPLAIN without ANALYZE show? What are the table definitions
and what are the results of the following queries?
SELECT COUNT(*) FROM IC;
SELECT COUNT(*) FROM IR;
SELECT COUNT(*) FROM IR WHERE IRSTATUT IN (1, 2);
SELECT COUNT(DISTINCT IRICNUM) FROM IR WHERE IRSTATUT IN (1, 2);
Have you run VACUUM ANALYZE on the tables?
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/