Oracle Data Base

index is used to reduce the searches ...imp create the index

select m.plan_cd,plan_name,charge_type,plan_charge,charge_free,charge_rate  from plan_master m,plan_detail d where m.plan_cd=d.plan_cd;   # alias and condition  order by m.plan_cd, charge_type ;   #confirm...have doubt