AWS Database Blog
Author: Prema Iyer
Prema Iyer is a Senior Technical Account Manager at AWS based in Atlanta, GA. She works with enterprise customers to optimize their cloud operations, improve operational resilience, and adopt AWS services that simplify infrastructure management across hybrid and multicloud environments. Outside of work, she enjoys exploring ways technology can make operations teams more effective.
Improve query performance with EXPLAIN plans in Amazon Aurora DSQL
In this post, we show you how to use EXPLAIN plans to diagnose and improve query performance in Amazon Aurora DSQL. We introduce a three-layer filter model as a practical framework for understanding where your predicates are evaluated, and walk through the architecture differences that make Aurora DSQL plans unique, the anatomy of an EXPLAIN output, access method selection, and a step-by-step query improvement workflow.