Compute Units / Slots

Concept

A compute slot or processing unit is a virtual CPU and memory slice allocated by a database engine to execute query operations.

Layman Explanation & Analogy

Think of compute slots like checkout lanes at a busy supermarket. When you run a query, the database opens multiple lanes (slots) in parallel to scan and process your data faster. The more complex your calculation and joins, the more slot workers the database assigns to finish the job.

Worked real-world example

A simple query on 10,000 rows executes in 50 milliseconds using 2 slots. A complex query joining 50 million rows with sorting and heavy window functions consumes 100 slots for 10 seconds.

What people get wrong & common traps

Queries that join large tables on non-indexed or non-unique keys cause "data shuffling", consuming massive slot capacity and causing performance bottlenecks across your analytics dashboards.

Last reviewed August 28, 2026.