Same SQL - Different execution plan

 
HI,

We have a query in our 10.2.0.4 database that we are trying to tune

When we retrieved the execution plan from the shared pool using "select * from table(DBMS_XPLAN.Display_AWR('835y2491g7gud'));"

we got the following results


select case.case_No, case.manufacturer_Id, case.foreign_Exporter_id from Ad_Cvd_Case case
join Ad_Cvd_Case_Tariff tariff on (case.case_No = tariff.case_No) where
case.country_Origin =:1  and case.company_Case_Status_Cd = 'AC' and tariff.tariff_No = :2
and tariff.date_Tariff_Inactivated =

Plan hash value: 1573487993

---------------------------------------------------------------------------------------------------
| Id  | Operation                    | Name               | Rows  | Bytes | Cost (%CPU)| Time     |