Main Content

How to think in SQL, a set-based mindset

About the Talk

May 1, 2015 3:30 PM

Columbus, OH

Columbus, OH

One of the main sticking points for developers when they need to write SQL is thinking about the process the incorrect way. Java, C# and others require procedural thinking for optimization, but SQL optimization requires a different tactic, set-based thinking. In this talk, Kevin Devine, takes you through a number of SQL scenarios that were originally written procedurally and shows you how they were optimized using set-based thinking. We will talk about optimizer decisions like full scan, index fast full scan, index range scan, hash joins, merge joins, nested loops anti semi joins, lazy spool, hash aggregate and more. In addition, we will examine the fallacy of process-oriented thinking for SQL and focus on results-oriented thinking. At the end of this talk, you should be able to look at SQL differently and go home ready to optimize those hard to understand queries.

Ratings and Recommendations

Avg. Rating

Average based
on 1 rating

comments powered by Disqus