DistillPrep
Python
GenAI
GenAI Frameworks
NLP
Deep Learning
Machine Learning
ML Libraries
Statistics
SQL
MLOps
Cloud
System Design
Blog
Learn
Practice
Test
Live Engine
Select Topic
SQL Fundamentals
(15)
Filtering And Conditions
(15)
Joins And Set Operations
(15)
Aggregation And Groupby
(15)
Window Functions
(15)
Subqueries And Ctes
(15)
String And Date Functions
(15)
Indexing
(15)
Query Optimization
(15)
Transactions And Acid
(15)
Database Design And Normalization
(15)
Nosql Vs SQL
(15)
SQL For Data Science
(15)
easy
Query Optimization
A developer wants to understand why a query is slow. Which SQL command shows the query execution plan without actually running the query?
A
EXPLAIN query
— shows the estimated execution plan
B
EXPLAIN ANALYZE query
— shows the estimated plan AND runs the query with real timings
C
DESCRIBE query
— shows the execution plan
D
Both A and B show the execution plan without running the query
Previous
Back
Next