Hi,
I have a query where i am using result_cache hint, so for the first time it is taking normal execution time and for the second time onward, its execution time gets reduced to a great extent.
but when i am using the same query in a procedure and returning the result set with ref cursor, its execution time remains the same even after the first execution. but my understanding is that time should reduce after first execution.
In all execution, i am keeping all constant values as same.
Please let me know why is this behavior different in query and procedure.
Thanks,
Vipin Kumar Rai