Tuning SQL queries is a very large topic. You can start with Oracle's Performance Tuning Guide.
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
One of the best books on the market is Guy Harrison's Oracle SQL High Performance Tuning. The book is a bit dated, but it does a really good job of showing the SQL tuning process. Here is a more up-to-date book.
Disclaimer: The links above direct you to Amazon.com. These links are, in no way, meant as an attempt to force you to order the books from Amazon. Feel free to order from any other source.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.