Gursimran Singh wrote:Gursimran, could you please clarify your suggestions for improving the precise way of fetching rows faster?
The most precise way for fetching rows faster can be attained in number of ways.
1. The first way is apply indexes and in case indexes got large number of deletions then rebuild it.
2. The next way is the optimizer you are choosing.
Literaly these parameters are effective then this thing will automatically lead to faster fetching.