6 Replies Latest reply on Aug 4, 2012 2:54 AM by indra budiantho

    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