Hi Team,
Cheers to Sergey and to his team !
Well I faced a problem recently and was resolved also. I am putting it here, because it may help someone in similar problems to expedite the process. We migrated oracle from 9i to 11g. The query on list page was taking too much time to execute (actually query was not getting executed at all) and was showing "Loading" screen constantly (for hours together !) . I tried to optimize the tables/ indexes in enterprise manager of oracle but all in vain. I tried to put off the count detail rows also but still no luck. The tables were not heavily loaded actually, we have more heavy tables with millions of rows executing fine in seconds.
Finally I had a luck and i put the search settings off for the list page, and VOILA ! the query executed in seconds.
Thank you.