1 Reply Latest reply on Oct 9, 2013 12:38 PM by Paul Horth

    Varying index performance.


      Database -

      OS          - AIX.


      Hi all,


               I have been facing some performance issues lately with one of the application queries. After monitoring query execution we have reliazied one of the table lookup is taking more time. This so called table being accessed through index range method. Problem is, query takes less time(5 mins) if few queries are accessing that problematic table(all queries are using same index) parallely but the case is entirely different if say more queries(>10 and < 20 - query count) are trying to pull data from that same table(again same index). Could some one please explain me what are the reasons behind this? or what could be the way to identify the same?.