Home » RDBMS Server » Performance Tuning » SQL Query for tuning (SQL Query for tuning)
SQL Query for tuning [message #272955] Mon, 08 October 2007 06:17 Go to next message
kr_arvind
Messages: 85
Registered: April 2006
Location: Delhi
Member
Hi All,

The given query is too slow can u suggest me how can tune, all are the view.

ELECT DISTINCT
t2.supplier_ordpoint,
t1.supplier_userid,
t3.supplier_ordpoint_telephone,
t1.cont_name,
t1.scnr_ackw_date,
t1.cont_name_title,
t4.pmqe_userid
FROM pq.snet_supp_cont_lnk t2
--where 1=0
LEFT JOIN PQ.SNET_SCNR_MASTER T1
ON T1.SUPPLIER_ORDPOINT = T2.SUPPLIER_ORDPOINT LEFT JOIN PQ.SNET_SUPP_MASTER T3
ON T3.SUPPLIER_ORDPOINT = T2.SUPPLIER_ORDPOINT LEFT JOIN PQ.PQ_RMS_PMQE_BUYER T4
ON T4.SUPPLIER_CODE = T2.SUPPLIER_ORDPOINT WHERE T2.SUPPLIER_ORDPOINT >'A'
AND T3.GE_UNIT = 'D18000' AND
MONTHS_BETWEEN (SYSDATE, SCNR_ACKW_DATE)<=12AND SCNR_ACKW_DATE>=TO_DATE('9/1/2007 00:00:00','MM/DD/YYYY HH24:MI:SS')
AND SCNR_ACKW_DATE<=TO_DATE('10/1/2007 23:59:59','MM/DD/YYYY HH24:MI:SS')


Thanks
Arvind
Re: SQL Query for tuning [message #272959 is a reply to message #272955] Mon, 08 October 2007 06:32 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I can move the post to the Performance Tuning forum, wherein you can read the big yellow post at the top, provide the requested information and we'll have a look at it.
Previous Topic: How to make table scan faster
Next Topic: What are the keep tables and indexes in Oracle HRMS, Oracle Financials and Oracle Payroll
Goto Forum:
  


Current Time: Mon Dec 05 15:17:30 CST 2016

Total time taken to generate the page: 0.13200 seconds