Am Mon, 2003-06-30 um 13.56 schrieb Chris Boget:
> which, sadly, is greek to me. The problem is that the above query
> takes very close to 12 seconds to execute. Is there a better way I
> could write the query? The number of rows in each table are as
> follows:
First of all you should try: VACUUM ANALYZE;
HTH
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : http://www.e-trolley.de