I am currently writing integration tests for my application. So I wanted to make sure that all queries are appropriately using indexes. My intention was to request all unique queries from system.profile and to run explain plans and see whether indexes used.
This could not be completed, as there is no sorting information in the system.profile however sorting affects indexes. My request to include sorting into system.profile