Education (depraced!) > FREE SQL Performance Explained by Markus Winand

FREE SQL Performance Explained by Markus Winand


Date: 8 June 2011 | Posted by: kotakhet
FREE SQL Performance Explained  by Markus Winand


"SQL Performance Explained" by Markus Winand. It is a free guide to SQL performance for developers. Unlike many other SQL performance tuning resources, "SQL Performance Explained" avoids unnecessary details about database internals but highlights the most important topic for fast SQL: proper indexing. SQL Indexing is a vendor independent topic. You know, they all put their pants on one leg at a time. However, different products use different terms for the same feature. "SQL Performance Explained" covers IBM DB2, MySQL, Oracle, PostgreSQL and Microsoft SQL Server explicitly to show where they differ, and where not. The main text uses the Oracle database's terms only—for a better reading experience.



SOURCE URL FOR FREE SOFTWARE
http://sql-performance-explained.com/

See full article