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

    Tuning Query

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



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

      version of the database is

      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