Subject Re[6]: [ib-support] Strange query problem
Author Alexander Tabakov
> 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@...