Need SQL Tuning help
- Hi Guys,
How are you all doing.
I need some help in tuning the below SQL
Statements.These are performing highest disk
reads.Buffer cache hit ratio sometimes comes to below
40% because of these.
select data, tablename, max_tablename, action,
transid, transorder, userid, extsystem, extexit,
ifacecontrol, emailsent from mout_interdata order by
transid, transorder, rowstamp
select * from wfassignment where assignstatus=
'ACTIVE' and ( (siteid is null) or (exists (select *
from siteuser where username= 'SLMNJXG' and
laborcode=wfassignment.assigncode and siteid =
wfassignment.siteid))) order by siteid asc, priority
SELECT COUNT (*) WONUM FROM WORKORDER WHERE (status !=
'WOCOMP' and status != 'WOCOMP' and status != 'COMP'
and status != 'CLOSE' and status != 'CAN' and
leadcraft = 'NGWAGS001')
select * from workorder where ((historyflag = 'N' and
istask = 'N')) and (siteid = 'ABSSITE') order by
select * from workorder where siteid = 'ABSSITE' order
select f.recordkey, f.description wf_descr,
q.woassignmntqueueid, f.assigncode, f.assignstatus,
w.description wo_descr, w.location, l.description
loc_descr, w.reportdate, w.worktype, w.status,
w.changedate, w.changeby from wfassignment f,
workorder w, locations l, woassignmntparty q where
f.recordkey = w.wonum and w.location = l.location and
f.assigncode = q.respparty (+) and f.assignstatus =
'ACTIVE' and w.location like '07%' and (w.wonum in
(select wonum from plustwpserv) or w.wonum in (select
refwo from labtrans)) order by f.recordkey,
Any help would be really appreciated.
Thank you guys.
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around