6 Replies Latest reply: Aug 3, 2012 9:54 PM by indra budiantho RSS

    Tuning Query

    User910243567
      Can you please help me in tuning the below query to bring down LIO ratio. I triedto use hints but no luck.

      Query:
      --------------------------------------------

      ------------------------------------------------------------------------

      It should display the delivery details based on parameters trip, delivery and warehouse.

      version of the database is 10.1.0.4

      ----------------------------------------
      Below is the explain plan
      ----------------------------------------
      I have posted the all the information i have,can you check.
      
      Edited by: User910243567 on Aug 1, 2012 1:58 PM
      
      Edited by: User910243567 on Aug 17, 2012 1:30 PM