| SQL Query for tuning [message #272955] |
Mon, 08 October 2007 06:17  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
