> This query without the WHERE clause executes fast (1400 ms). When
> I put the WHERE clause it goes to something like 15 minutes :((

It was my mistake. Actually somebody restored the database without
creating the indexes. So, after the second database restore everything
is OK.

Nevertheless, I will try the join versions of this query and if there
is some significant difference I will post the results here.

Thank you all.

--
Best regards,
Alexander mailto:saho@...