Reported By: Chris Holland Reported On: 3/2/2005 For: Version 4.17 Build 1
# 1988Joins Being Executed for JOIN Queries Even Though Driver Table Contains No Records If I run the following code it takes about 3 seconds to execute even though the "SupplierAgreed" table is empty.
If I remove the Join the result is instant. It is also instant if I empty the Database table. SupplierAgreed is indexed by Supplier and Database is indexed by PIN (case-insensitive). I would have expected that if SupplierAgreed was empty that the join would do nothing.
Select S.PIN,S.Discount,D.MainDesc
FROM SupplierAgreed S
JOIN Database D ON D.PIN = S.PIN
WHERE Supplier=1
ResolutionFixed Problem on 3/5/2005 in version 4.18 build 1