[Solved] Given this dbt model SQL snippet:select customer_id, sum(amount) as total_salesfrom ordersgroup by customer_idWhich index would most improve query performance? | dbt

dbt - Performance Optimization

Given this dbt model SQL snippet:

select customer_id, sum(amount) as total_sales
from orders
group by customer_id

Which index would most improve query performance?

AIndex on customer_id column

BIndex on amount column

CIndex on total_sales column

DNo index needed

Step-by-Step Solution

Solution:

Step 1: Analyze the query's grouping column
The query groups by customer_id, so indexing this column speeds grouping and aggregation.
Step 2: Evaluate indexing other columns
Indexing amount or total_sales (an alias) won't help grouping performance.
Final Answer:
Index on customer_id column -> Option A
Quick Check:
Group by column index = customer_id [OK]

Quick Trick: Index columns used in GROUP BY for faster aggregation [OK]

Common Mistakes:

MISTAKES

Master "Performance Optimization" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

Given this dbt model SQL snippet: