A question about SQL optimization:
Does anyone have any intermediate-level books/resources they can recommend about SQL optimization?
I've read the book in the link below (SQL Optimization Explained by Markus Winand). But it was pretty advanced and a few chapters were over my head/very detailed. I would benefit from having more concise guidelines about Oracle SQL performance best practices and clear instructions about how to use Oracle explain plans. I don't think explain plans and performance troubleshooting need to be as complicated as a lot of resources make them out to be.