Dear TerryD,

Sorry I have forgotten to supply the sequel statement. This is the statement :-

delete plan_table
where statement_id = 'STMT1'
/
EXPLAIN PLAN
SET STATEMENT_ID = 'STMT1'
FOR
select * from wl_details a
where a.billcycle = '03'
and a.app_date is not null
and a.service is not null
and a.custcode = '1.611832'
and a.app_date = (select max(b.app_date)
from wl_details b
where billcycle = '03'
and app_date is not null
and service is not null
and custcode = '1.611832')

Thanks