Just a quick post today to refer my readers to a series of blog posts that I recently made to the IDERA database community blog.
This four-part blog series took a look into SQL performance and optimization from a generic perspective. By that I mean that I did not focus on any particular DBMS, but on the general things that are required of and performed during the optimization of SQL.
Part one – Relational Optimization, introduces and explains the general concept of relational optimization and what it entails;
Part two – Query Analysis and Access Path Formulation, examines the process of analyzing SQL queries and introduces the types of access that can be performed on a single table;
Part three – Multiple Table Access Methods – takes a look at optimization methods for combining data from more than one table
And finally, part four – Additional Considerations – concludes the series with an overview of several additional aspects of SQL optimization that we have yet to discuss.
If you are looking for a nice overview of SQL and relational optimization without DBMS-specific details, give these posts a read!