Both fields are indexes.

This query works fine on "text" field... And when I change my query for a
INNER JOIN like this:

INNER JOIN RapportFiduciePart5
ON "" & Cheque.IDCHEQUE= "" & RapportFiduciePart5.refNSF;

It's a lot faster! (But still about 20 seconds.... (better compared to an
endless query)

----- Original Message -----
From: Hugo Hiasl
To: firebird-support@yahoogroups.com
Sent: Monday, June 06, 2005 12:26 PM
Subject: RE: [firebird-support] Why the JOIN is soooo long? (Forget the
first message!)


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










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

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

To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.