What's a Spill

A spill occurs when operations like sorts, joins, or aggregations require more memory than is available, causing intermediate data to be written to temporary disk storage instead. This typically happens in the temporary tablespace and can significantly slow down performance due to increased disk I/O. Spills indicate that a query exceeded its in-memory processing capacity and may benefit from SQL tuning.