Education (depraced!) > FREE SQL Performance Explained by Markus Winand
FREE SQL Performance Explained by Markus WinandDate: 8 June 2011 | Posted by: kotakhet |
![]() "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 |