Hi,

Any body helps me how to tune federated database objects ...Like i am facing one issue when i am passing dynamic sql to SQL which should fetch values from federated datasource.its really taking huge time to respond.

if suppose if i pass SQL with static values the results are coming very fast.You can find the examples below.

1.THe below is the querry which is taking long time to fetch only 2660 records.dynamic values should fetch from MQT table.

SELECT a.ACCOUNT_ID,
       a.Week_Ending_Date,
       a.Emp_Last_Name,
       a.Emp_Ser_Num,
       a.Country_Code,
       a.Division_Code,
       a.Emp_Dept_Number,
       a.Emp_Level_Code,
       a.Total_Hrs_Expended,
       b.COUNTRY_DESC
  FROM USER1.LABOUR_DETAILS_UV a,
       USER1.COUNTRY_REF_DETAILS b
    WHERE a.country_code = b.country_cd
    AND a.account_id IN (select * from DB2ADMIN.CLAIM_MQT_TAB);

2.if we pass same with static values its giving results very fast...some thing like below .

SELECT a.ACCOUNT_ID,
       a.Week_Ending_Date,
       a.Emp_Last_Name,
       a.Emp_Ser_Num,
       a.Country_Code,
       a.Division_Code,
       a.Emp_Dept_Number,
       a.Emp_Level_Code,
       a.Total_Hrs_Expended,
       b.COUNTRY_DESC
  FROM USER1.LABOUR_DETAILS_UV a,
       USER1.COUNTRY_REF_DETAILS b
    WHERE a.country_code = b.country_cd
    AND a.account_id IN ('X','Y','Z');

your help is appricaite.

Regards

kanak