Conceptual
Browse Instruct Curate
Login

About SQL Query Optimization: Plans, Indexes, and Joins

Copied

Learn to read what the database actually does with your query and to change it deliberately. You will interpret EXPLAIN and EXPLAIN ANALYZE output, understand how the cost-based optimizer uses statistics to pick scans, join algorithms, and join order, design indexes (composite, covering, partial, expression) that the planner will actually use, keep predicates sargable, and diagnose the classic performance killers: cardinality misestimates, N+1 query storms, and unprunable partitions.

Estimated Time to Complete

Only available after login

What You'll Learn

Concepts:
Expression Index Merge Join Correlated Subquery Rewriting Sargable Predicate Join Order Optimization Nested Loop Join Composite Index Column Order Cost-Based Query Optimizer Covering Index Partial Index N+1 Query Problem Partition Pruning Reading an EXPLAIN Plan Hash Join Cardinality Estimation Error EXPLAIN ANALYZE

What you will learn

No introduction video available

About Demerzel

D

Guide profile coming soon.