Loading ...
Sorry, an error occurred while loading the content.
 

Need SQL Tuning help

Expand Messages
  • shyamraj arippa
    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
    Message 1 of 1 , Jun 29, 2006
      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
      desc


      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
      reportdate

      select * from workorder where siteid = 'ABSSITE' order
      by reportdate

      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,
      f.description


      Any help would be really appreciated.

      Thank you guys.

      Regards

      Shyam

      __________________________________________________
      Do You Yahoo!?
      Tired of spam? Yahoo! Mail has the best spam protection around
      http://mail.yahoo.com
    Your message has been successfully submitted and would be delivered to recipients shortly.