Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
Job-ready SQL and database skills
·
Module 10
Query Performance and Optimization
1
Indexing for Faster Data Retrieval
Explain how indexes (e.g., B-Tree) speed up data retrieval.
2
Optimizing Queries with Single-Column and Composite Indexes
Create a single-column or composite index to optimize a query.
3
Indexing Trade-offs: Write Performance and More
Describe the trade-offs of using indexes, including write performance overhead.
4
Optimizing Queries with Execution Plans
Use a query's execution plan to identify performance bottlenecks like a full table scan.
5
Optimizing `WHERE` Clauses for Index Usage
Rewrite a non-SARGable `WHERE` clause condition to enable index usage.
6
Optimizing Queries: JOIN vs. Correlated Subquery
Determine when to use a `JOIN` instead of a correlated subquery for better performance.
7
Understanding the Query Optimizer
Explain the role of the query optimizer in choosing an execution plan.
Previous module
Transactions and Concurrency
Next module
Advanced Analysis with Window Functions