Subject Simple SELECT statement causes long running query
Author Christian Gütter
Hi,

running the following query against Firebird 1.50
causes the server to compute for a very long (infinite?)
time:

SELECT MAX (T1.ID),
MAX (T2.ID)
FROM Table1 T1, Table2 T2

The two ID Fields are PKs, both table contain approximately
25 K records.

I have never used such a query before, so I am wondering
if it is valid or invalid and what is causing Firebird to
work so long.


Thanks in advance,


Christian