Menu▾
Data Lab

Add the index

Same warehouse, same query from the last chapter. This time you'll add the index that's missing, then re-run the query and read the new plan side by side with the old one. The point isn't memorising CREATE INDEX syntax — it's building the habit of checking whether an index actually changed the plan, instead of assuming it did.

Basic

This is a Basic-beta Data Lab chapter

Data Lab works one 12-table warehouse end to end — clean it, join it, aggregate it, make it fast. It's included free with Basic.

See Basic plans

RM 25/mo · cancel anytime