DBohner-(db)
Legendary Poster
Using BSVW V8300001 - I do Data Selection a:
F0902.Ledger Type = AA
F0902.OBJ 3000-4500
F0901.Company = 65
F0902.Year = 9
What I get is:
WHERE ( ( ( T1.GBLT = 'AA' OR T1.GBLT IS NULL ) AND ( T1.GBOBJ BETWEEN '3000' AND '4500' OR T1.GBOBJ IS NULL )
AND T0.GMCO = '00065' AND ( T1.GBFY = 9.000000 OR T1.GBFY IS NULL ) ) ) ORDER BY T1.GBMCU ASC,T1.GBSBL ASC
Note all the nulls??? WTH? From a performance aspect, it goes from selecting the 11,018 records it should have selected to 578,188 records it did select (with the F0902 NULLs)
Is this the way Outer Joins should work? Why does the crazy "OR NULL" have to be appended to each row of Data Selection?
Performance SUCKS!
(db)
F0902.Ledger Type = AA
F0902.OBJ 3000-4500
F0901.Company = 65
F0902.Year = 9
What I get is:
WHERE ( ( ( T1.GBLT = 'AA' OR T1.GBLT IS NULL ) AND ( T1.GBOBJ BETWEEN '3000' AND '4500' OR T1.GBOBJ IS NULL )
AND T0.GMCO = '00065' AND ( T1.GBFY = 9.000000 OR T1.GBFY IS NULL ) ) ) ORDER BY T1.GBMCU ASC,T1.GBSBL ASC
Note all the nulls??? WTH? From a performance aspect, it goes from selecting the 11,018 records it should have selected to 578,188 records it did select (with the F0902 NULLs)
Is this the way Outer Joins should work? Why does the crazy "OR NULL" have to be appended to each row of Data Selection?
Performance SUCKS!
(db)