I have two BQ tables that have the same data, one has yearly partitions on a date field while the other has no partitions. I ran the same query against both the tables, basically a simple Select all query for a specific year. The following execution details are available for the two queries: