Icon View Incident Report

Minor Minor
Reported By: Roy Lambert
Reported On: 7/20/2010
For: Version 2.03 Build 17
# 3251 SQL Execution Plan Hints Showing Incorrectly for Certain Conditions

The following query results in a weird hint in the execution plan:

Row scan (Companies): 7128 rows, 3364416 bytes estimated cost

Hint: Create index (Companies) on column "_fkOrgType","_fkOrgType","_fkOrgType"
"_fkOrgType","_fkOrgType" for possible better performance

"_ID" AS "_ID"
FROM "Companies" INNER JOIN "Career" ON "_fkCompanies" = "Companies"."_ID"
WHERE ("_fkOrgType" = 'A/ELEC' OR "_fkOrgType" = 'AERO' OR "_fkOrgType" =
'APPLEGATE' OR "_fkOrgType" = 'CAPEX' OR "_fkOrgType" = 'DEFENCE' OR "_fkOrgType" =
'ELECTRONIC' OR "_fkOrgType" = 'HQ' OR "_fkOrgType" = 'MAKER' OR "_fkOrgType" =
'MECHENG' OR "_fkOrgType" = 'NONCORE' OR "_fkOrgType" = 'PHARM' OR "_fkOrgType" =
'PROCESS') AND EXISTS (SELECT ALL "_fkCompanies" AS "_fkCompanies" FROM
"Career" WHERE "_fkCompanies" = "Companies"."_ID" AND "_fkJobCodes" IN ('GM', 'CEO',
'MD')) <> TRUE

Resolution Resolution
Fixed Problem on 7/21/2010 in version 2.03 build 18

Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial