explain plan for select --+ use_concatcount(*) as card_cnt,pc.card_draft_type,pc.issue_point_id,pc.file_to_production_id as file_idfrom pers_card_pc pc,pers_drafts_pers_batch b,pers_session s,pers_file_to_production fwhere s.lead_executive = :land s.distributor_executive = :dand s.pers_executive = :pand ( :fSesId isnull and :fBatchId is not null
(
Read more... )
Reply
Reply
Reply
Reply
Reply
Reply
Leave a comment