Bigquery, Execution Plan, Query Optimization.
system (Local disk): only use when data can not fit in RAM. If data is spilled into disk, it can cause performance to slow dramatically. Given that the performance characteristics of disk are fundamentally different from memory, BigQuery takes special care to automatically organize data in such a