Hi all, I have used compact index for my table and the response time is same for a query with as well as without index now. Previously, it was showing improvement. I just changed some parameters to increase heap size and then it is behaving weird. so, how can I make sure that my query is using index?
Thanks, Siddharth