rewrite the sql query

From: dmarsha3 <dmarsha3_at_csc.com>
Date: 20 May 1999 17:29:01 GMT
Message-ID: <7i1got$ecq$1@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 - 12:29:01 CDT