On 09/28/2018 12:51 PM, Arup Rakshit wrote:
>
> Yes, I have shown the explain plan output. But in my application log
> the sql query prints 1.7 to 1.9 ms.
>
>
How often does the production app make this call? Apparently it could
do it 500 times per second. But at such a rate the network overhead
would be stupendous - you might think about getting more data per call,
few calls.