Database - 220.127.116.11.0
OS - AIX.
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?.
Please read the links given in Re: 3. How to improve the performance of my query? / My query is running slow.
and provide the information asked for.
Of course it could simply be that your hardware can handle 5 queries but not 10-20.