sql tuning | calculating logical reads made by a query
one day a dba reported high resource usage by a query, but it was 'well-optimized' and the runtime was as expected, then what was wrong? logical read was high.
to calculate logical reads made by a query:
DECLARE
READS NUMBER;
OUTPUT NUMBER;
...
0xweathered.hashnode.dev1 min read