Query performance
Hi All,
We are using 10.2.0.4 db on AIX and we refresh a particular schema in our dev environment from production every week.
This time after refresh we noticed that the following query is taking lot of time to execute.
SELECT DISTINCT t.promo_gentd_id, cal_start.date_time_stamp start_date, cal_end.date_time_stamp end_date
FROM TSL_PROMOTION t, TSL_CAL_TIME_REASN_FOR_PROMO cal_start, TSL_CAL_TIME_REASN_FOR_PROMO cal_end
WHERE t.source_system_table_name = 'ORPMLOCDTL'
AND t.srce_system_promo_id = '8'
AND t.promo_gentd_id = cal_start.promo_gentd_id
We are using 10.2.0.4 db on AIX and we refresh a particular schema in our dev environment from production every week.
This time after refresh we noticed that the following query is taking lot of time to execute.
SELECT DISTINCT t.promo_gentd_id, cal_start.date_time_stamp start_date, cal_end.date_time_stamp end_date
FROM TSL_PROMOTION t, TSL_CAL_TIME_REASN_FOR_PROMO cal_start, TSL_CAL_TIME_REASN_FOR_PROMO cal_end
WHERE t.source_system_table_name = 'ORPMLOCDTL'
AND t.srce_system_promo_id = '8'
AND t.promo_gentd_id = cal_start.promo_gentd_id
0