Re: rewrite the sql query

Create the table "plan_table" using utlxplan.sql

Add before the sql statement explain plan set statement_id = 'XX' for

select the lines from the table plan_table where statement_id = 'XX' This will give you an explanation how the statement is executed by the server.

Gert

dmarsha3 <dmarsha3_at_csc.com> wrote in article <7i1got$ecq$1_at_lore.csc.com>...
>
> Group:
>
> I have the following sql query
>
> select
> f.folder_id, rd.pr_number,c.contract_number,
> p.nsn,rsa.solicitation_number,c.contractor_cage,f.archive_status_flag,
> f.folder_obj_id,
> f.gdms_instance_nm, f.frag_id
> from
> ecf_folder f,ecf_contract_data c,ecf_folder_req_assoc fra,
> ecf_requisition_data rd,
> ecf_req_soli_assoc rsa, ecf_pr_nsn_assoc p
> where
> f.folder_id=c.folder_id(+) and
> f.folder_id=fra.folder_id(+) and
> fra.ecf_req_data_seq_id=rd.ecf_req_data_seq_id(+) and
> rd.ecf_req_data_seq_id=rsa.ecf_req_data_seq_id(+) and
> fra.ecf_req_data_seq_id = p.ecf_req_data_seq_id(+);
>
> It's taking around 16 seconds right now.
> I would like to speed up this query is there any other method to do it.
>
> Any help is appreciated.
>
> rama
> rkolluru_at_csc.com
>
Received on Thu May 20 1999 - 13:15:36 CDT