SELECT   Script.*
FROM "Script"  
   INNER JOIN (SELECT * FROM Claim WHERE ClaimPeriodNumber = 1012) Claim1
      ON Script.ClaimId = Claim1.ClaimId
JOINOPTIMIZECOSTS

---

 Comments

---

The derived table was returning 0 rows, which was matching on several thousand rows in the Script table with a Claim column containing a NULL value. This fact confused the join optimizer and made it think that it was more efficient to keep the join ordering as-is. The optimizer now correctly does not compute join costs for tables or derived tables with zero rows in them.

---

 Resolution

---

Fixed Problem on 4/27/2010 in version 2.03 build 13

---

 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