Sql Tune to improve buffer gets
Before buffer get tune. SQL plan was doing index fast full scan. here is you can see that
After running SQL tuning adviser that suggest to implement new profile that took index rang scan and buffer get improved dramatically also CPU cost.
as you can see above buffer get reduced from 22K to 615 and CPU cost reduced from 772 to 1. huge improvement.