Ask the Expert

Where can I learn to tune SQL queries?

Hi Brian. I like to read your topic very much. Where can I get the materials to learn how to tune SQL queries? Any Web sites?

    Requires Free Membership to View

Tuning SQL queries is a very large topic. You can start with Oracle's Performance Tuning Guide.

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.

This was first published in May 2006

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: