Materialize the Query Result for Performance

Materialize the query result for multistage queries to make your query faster and lower the costs.

Write the results to a table for multistage query it is costing to much data.

Many operations, such as row_number, costs a lot more data than the selected columns. Writing to a destination table would save some data.

Planted: by ;

Lei Ma (2019). 'Materialize the Query Result for Performance', Datumorphism, 05 April. Available at: