SQL Performance question

Posted in 2017

WENCHING CHIANG — Fri, 22 Dec 2017 20:35:19 — source: IIUG Forums & Mailing Lists

Hi, I am working SQL tuning case, after I re-writed the sql with temp table. It reduced bufreads of sql from 68,000 to 37,000, but it increased bufwrites from 31 to 480. This sql will execute several million times daily in our system. My question is how can I evaluate the changes will help the performance or negative impact the performance ? If there are any rules to evaluate bufreads vs bufwrites. Version : 12.10.FC7AEE OS : Linux. Thanks Wen-Ching