Well ... thank you but ... it was not a problem in older 2.5.x versions. But I also tried with:
select "PROC" from "PROC" where exists (select 1 from .... But it also needs 24 minutes. I know it is better a join, but in my queries it is possible to check "IN" up to 18 other sub-queries, so I have to use a way like this. 24 minutes is not acceptable for checking 46k records even if we do that one by one. And as I said, under older 2.5.x it works very fast. Dany
