Icon View Incident Report

Minor Minor
Reported By: Chris Holland
Reported On: 3/2/2005
For: Version 4.17 Build 1
# 1988 Joins 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

Resolution Resolution
Fixed Problem on 3/5/2005 in version 4.18 build 1