Work out query scan cost instantly with clear inputs, formula shown and shareable results.
Scan-based pricing charges per byte read, so cost is entirely determined by how much data each query touches. Partition pruning and columnar projection are the levers: 92 percent pruning turns a 20 TB table scan into 1.6 TB, and selecting three columns from a hundred cuts it again. Without pruning, 800 daily queries over 20 TB would cost over two million a month.
Scan cost
scanned per query = table size x (1 - pruning); monthly = scanned x queries x 30.44 x price per TB
Partition on the column most queries filter on, usually a date, and ensure the filter is a literal predicate the planner can evaluate — a function applied to the partition column disables pruning.
Enormously. Columnar formats only read the columns referenced, so selecting all of them can multiply the scan by ten or more.