What Indexes did you define on the tables? Do you have indexes for both
fields used in the INNER JOIN?

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of mona yazbeck
Sent: Montag, 6. Juni 2005 17:32
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Why the JOIN is soooo long? (Forget the first
message!)


Hello,

I've been working on one particular query that gives me so much trouble.

SELECT Cheque.DATEDEPOT, RapportFiduciePart5.IDGROUPE,
RapportFiduciePart5.IDDOSSIER, RapportFiduciePart5.NOCHEQUE,
RapportFiduciePart5.montantClient AS MontantTot,
RapportFiduciePart5.chequeRemis, RapportFiduciePart5.nomComplet,
RapportFiduciePart5.DATEDEPOT AS DateDuDepotDuCheque,
RapportFiduciePart5.IDCHEQUE
FROM Cheque
INNER JOIN RapportFiduciePart5
ON Cheque.IDCHEQUE= RapportFiduciePart5.refNSF;

IDCHEQUE and refNSF are both INTEGER. When I do a similar query with One
integer and one Text Field using "" & integer = text, it works great.

RapportFiduciePart5 is a Query and alone, it runs pretty fast
Cheque is a Table

Any ideas?

Thanks


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links