Subject | Simple SELECT statement causes long running query |
---|---|
Author | Christian Gütter |
Post date | 2004-07-29T10:55:46Z |
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
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