COURSE 18 OF 22
Storage and Query Performance
Choose files, partitions, and table layouts from the queries they must serve.
Background reading
Introduction to Storage and Query Performance
The delivery report needs yesterday’s city and charge columns. Yet the job reads a year of wide JSON records. Before adding machines, ask how much unnecessary data the query reads.
Storage design changes the work a query performs. File format, layout and statistics influence which bytes can be skipped and how much processing remains.
Loading course…