Go back
Optimizing Query Execution Time through Database Partitioning for FoodWagon
9 Inputs
1 Hour 30 Minutes
Advanced
.webp&w=3840&q=75)
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 Partitioning 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
- Basic knowledge of how to partition Tables in Relational Database
- Familiarity with relational database design & Modelling
- Familiarity with Catalog and System views of Postgres