working of plan table!!!

column options format a30
column optimizer format a30
column statement_id format a10

delete from plan_table where statement_id = ‘m1′;

explain plan set statement_id = ‘m1′
for
select sales_town.town_descr,sum(sm_sales_exp.net_sales_val) as sum_net_sales_val_24 from sales_town,sm_sales_exp where ((sm_sales_exp.prd_code >= ‘200804′) and (sm_sales_exp.prd_code <= ‘200810′) and (sm_sales_exp.terr_code in (select territory_code from sales_station
where territory_descr like ‘nellore%’ and (town_descr like ‘tirupati%’ or town_descr like ‘madana%’)) ) and (sm_sales_exp.item_ser = ‘rd’) ) group by sales_town.town_descr ;

select statement_id,operation,options,object_name,object_type,optimizer,search_columns,position
from plan_table where statement_id = ‘m1′;