title: What resources exist for Database performance-tuning?
body: <p>What good resources exist for understanding database tuning on the major engines and advancing your knowledge in that area?</p>
  
  <p>The idea of this question is to collect the shed load of resources that invariably exist, so that people can have a "one stop" knowledge shop of the good, peer approved resources.</p>
  
  <hr />
  
  <p><strong>General SQL</strong></p>
  
  <ul>
  <li><a href="http://books.google.com/books?id=3H9CC54qYeEC&amp;dq=sql+performance+tuning&amp;printsec=frontcover&amp;source=bn&amp;hl=en&amp;ei=1dDoSYmjMOrlnQfX-bSYBw&amp;sa=X&amp;oi=book_result&amp;ct=result&amp;resnum=4" rel="nofollow noreferrer">Book: SQL Performance Tuning</a></li>
  <li><a href="http://books.google.com/books?id=pKXF7UU0gBYC&amp;printsec=frontcover&amp;dq=sql%2Btuning" rel="nofollow noreferrer">Book: SQL Tuning</a></li>
  <li><a href="https://rads.stackoverflow.com/amzn/click/com/0596008945" rel="nofollow noreferrer" rel="nofollow noreferrer">Book: The Art of SQL</a></li>
  <li><a href="http://books.google.com/books?id=gjyd3IOrwz4C&amp;lpg=PP1&amp;dq=refactoring%20sql%20applications&amp;pg=PP1#v=onepage&amp;q&amp;f=false" rel="nofollow noreferrer">Book: Refactoring SQL Applications</a></li>
  <li><a href="http://books.google.com/books?id=1CJdgVO8PwAC&amp;lpg=PR21&amp;dq=database%20tuning%20principles&amp;pg=PP1#v=onepage&amp;q&amp;f=false" rel="nofollow noreferrer">Book: Database tuning: principles, experiments, and troubleshooting techniques</a></li>
  <li><a href="http://Use-The-Index-Luke.com/" rel="nofollow noreferrer">Use The Index, Luke! - A Guide to database performance for developers</a></li>
  </ul>
  
  <p><strong>PostgreSQL</strong> (<a href="http://wiki.postgresql.org/" rel="nofollow noreferrer">wiki</a>) (<a href="http://www.pgsql.ru/db/pgsearch/" rel="nofollow noreferrer">PGsearch</a>)</p>
  
  <ul>
  <li><a href="http://wiki.postgresql.org/wiki/Performance_Optimization" rel="nofollow noreferrer">Performance Optimization</a></li>
  <li><a href="http://www.mohawksoft.org/?q=node/56" rel="nofollow noreferrer">Quick PostgreSQL Optimization</a></li>
  <li><a href="http://explain.depesz.com/" rel="nofollow noreferrer">Explain Analyze Interpreter</a></li>
  <li><a href="http://www.postgresql.org/docs/current/static/performance-tips.html" rel="nofollow noreferrer">PostgreSQL Performance Tips</a></li>
  <li><a href="https://www.packtpub.com/postgresql-90-high-performance/book" rel="nofollow noreferrer">Book: PostgreSQL 9.0 High Performance</a></li>
  </ul>
  
  <p><strong>MySQL</strong></p>
  
  <ul>
  <li><a href="https://stackoverflow.com/questions/368858/hidden-features-of-mysql">Hidden Features of MySQL</a></li>
  <li><a href="http://oreilly.com/catalog/9780596101718/" rel="nofollow noreferrer">Book: High Performance MySQL</a> / <a href="http://www.mysqlperformanceblog.com/" rel="nofollow noreferrer">Blog: High Performance MySQL</a></li>
  <li><a href="http://www.xaprb.com/blog/" rel="nofollow noreferrer">Blog: Xaprb (for MySQL DBAs)</a></li>
  </ul>
  
  <p><strong>Oracle</strong></p>
  
  <ul>
  <li><a href="https://stackoverflow.com/a/34975420/146325">How to ask Oracle tuning questions on StackOverflow</a></li>
  <li><a href="https://stackoverflow.com/questions/79266/how-do-you-interpret-a-querys-explain-plan">How do you interpret a query's explain plan?</a></li>
  <li><a href="http://www.ixora.com.au/scripts/" rel="nofollow noreferrer">Oracle Advanced Tuning Scripts</a></li>
  <li><a href="http://download.oracle.com/docs/cd/B28359_01/server.111/b28274/toc.htm" rel="nofollow noreferrer">Oracle Database Performance Tuning Guide</a></li>
  <li><a href="http://asktom.oracle.com" rel="nofollow noreferrer">Ask Tom</a></li>
  <li><a href="http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/toc.htm" rel="nofollow noreferrer">Oracle Database SQL Reference</a></li>
  <li><a href="http://www.amazon.ca/Troubleshooting-Oracle-Performance-Christian-Antognini/dp/1590599179" rel="nofollow noreferrer">Book: Understanding Oracle Performance</a></li>
  <li><a href="https://rads.stackoverflow.com/amzn/click/com/059600527X" rel="nofollow noreferrer" rel="nofollow noreferrer">Book: Optimizing Oracle Performance</a></li>
  <li><a href="https://rads.stackoverflow.com/amzn/click/com/1590599179" rel="nofollow noreferrer" rel="nofollow noreferrer">Book: Troubleshooting Oracle Performance</a></li>
  <li><a href="https://rads.stackoverflow.com/amzn/click/com/1590596366" rel="nofollow noreferrer" rel="nofollow noreferrer">Book: Cost-Based Oracle Fundamentals</a></li>
  </ul>
  
  <p><strong>MS SQL Server</strong></p>
  
  <ul>
  <li><a href="http://www.sql-server-performance.com/index.aspx" rel="nofollow noreferrer">SQL Server Performance</a> </li>
  <li><a href="http://downloads.red-gate.com/ebooks/HighPerformanceSQL_ebook.zip" rel="nofollow noreferrer">eBook: High Performance SQL Server</a></li>
  <li><a href="https://stackoverflow.com/questions/103423/what-are-the-best-sql-server-performance-optimization-techniques">SO Question: What are the best SQL Server performance optimization techniques?</a></li>
  <li><a href="http://www.brentozar.com/sql-server-performance-tuning/" rel="nofollow noreferrer">Brent Ozar's Perf Tuning Page</a></li>
  <li><a href="http://www.toadworld.com/platforms/sql-server/w/wiki/9805.performance-tuning.aspx" rel="nofollow noreferrer">SqlServerPedia's Perf Tuning Page</a></li>
  <li><a href="https://rads.stackoverflow.com/amzn/click/com/0735626243" rel="nofollow noreferrer" rel="nofollow noreferrer">Book: Sql Server 2008 Internals</a></li>
  <li><a href="http://www.simple-talk.com/sql/performance/how-to-identify-slow-running-queries-with-sql-profiler/" rel="nofollow noreferrer">How to Identify Slow Running Queries with SQL Profiler</a></li>
  </ul>
  
  <p><strong>Sybase SQL Anywhere</strong></p>
  
  <ul>
  <li><a href="http://sqlanywhere.blogspot.com/" rel="nofollow noreferrer">Blog: SQL Anywhere</a></li>
  <li><a href="https://rads.stackoverflow.com/amzn/click/com/1556225067" rel="nofollow noreferrer" rel="nofollow noreferrer">Book: SQL Anywhere Studio 9  Developer's Guide</a></li>
  </ul>
  
  <p><strong>JDBC</strong></p>
  
  <ul>
  <li><a href="http://www.javaperformancetuning.com/tips/jdbc.shtml" rel="nofollow noreferrer">JDBC Performance Tips</a></li>
  </ul>