Optimizing your BigQuery Queries for Performance 2.5 Reviews

Good

Krishna Prasanth D. · Reviewed over 1 year ago

Klever T. · Reviewed over 1 year ago

Joey L. · Reviewed over 1 year ago

Edward W. · Reviewed over 1 year ago

typo "Similarly, query the dataset to find the most common female names in 2015 in the state of Massachusetts:", year incorrect

Tim W. · Reviewed over 1 year ago

Gyanendra-Singh R. · Reviewed over 1 year ago

Mose O. · Reviewed over 1 year ago

Omar Y. · Reviewed over 1 year ago

Katayun P. · Reviewed over 1 year ago

Jeffin K. · Reviewed over 1 year ago

Estefania M. · Reviewed over 1 year ago

ok

SUBHRO M. · Reviewed over 1 year ago

Reshu G. · Reviewed over 1 year ago

nakka n. · Reviewed over 1 year ago

Raju S. · Reviewed over 1 year ago

I'd like a cheat sheet with all of these examples!

Caden H. · Reviewed over 1 year ago

rajani l. · Reviewed over 1 year ago

Fernando B. · Reviewed over 1 year ago

While the lab is functional, the data in the lab is immensely outdated. BigQuery has made so many optimizations over the years that a few of these examples when you run then don't really show much of an optimization improvement. Some of them are as minor as 0.1 seconds, compared to the x2 or x3 improvements that are suggested in the lab. Each of the queries worked, but it would be nice to have improvements that looked more noticeable.

Prentice B. · Reviewed over 1 year ago

fei w. · Reviewed over 1 year ago

Ahmed T. · Reviewed over 1 year ago

Ahmed A. · Reviewed over 1 year ago

Carsten T. · Reviewed over 1 year ago

Leandro S. · Reviewed over 1 year ago

Yulia G. · Reviewed over 1 year ago