Go back
Optimizing Query Execution Time through Database Indexing for FoodWagon
8 Inputs
1 Hour 30 Minutes
Advanced
Industry
e-commerce
Skills
data-storage
data-modelling
Tools
sql
Learning Objectives
Use database monitoring tools to identify high-cost queries
Analyze execution plans to identify slow operations like table scans, nested loops, and expensive sorts.
Implement indexing strategies to minimize scan operations and improve query performance.
Overview
Prerequisites
- Ability to write intermediate to advanced SQL queries, including complex joins, aggregations, CTE & Sub Query
- Understanding of execution plans and query performance metrics.
- Basic knowledge of indexing and how it effects query performance
- Familiarity with relational database design & Modelling
- Familiarity with Catalog and System views of Postgres