Optimizing your BigQuery Queries for Performance 2.5 Reviews

Good

Krishna Prasanth D. · Reviewed מעל שנה אחת ago

Klever T. · Reviewed מעל שנה אחת ago

Joey L. · Reviewed מעל שנה אחת ago

Edward W. · Reviewed מעל שנה אחת 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 מעל שנה אחת ago

Gyanendra-Singh R. · Reviewed מעל שנה אחת ago

Mose O. · Reviewed מעל שנה אחת ago

Omar Y. · Reviewed מעל שנה אחת ago

Katayun P. · Reviewed מעל שנה אחת ago

Jeffin K. · Reviewed מעל שנה אחת ago

Estefania M. · Reviewed מעל שנה אחת ago

ok

SUBHRO M. · Reviewed מעל שנה אחת ago

Reshu G. · Reviewed מעל שנה אחת ago

nakka n. · Reviewed מעל שנה אחת ago

Raju S. · Reviewed מעל שנה אחת ago

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

Caden H. · Reviewed מעל שנה אחת ago

rajani l. · Reviewed מעל שנה אחת ago

Fernando B. · Reviewed מעל שנה אחת 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 מעל שנה אחת ago

fei w. · Reviewed מעל שנה אחת ago

Ahmed T. · Reviewed מעל שנה אחת ago

Ahmed A. · Reviewed מעל שנה אחת ago

Carsten T. · Reviewed מעל שנה אחת ago

Leandro S. · Reviewed מעל שנה אחת ago

Yulia G. · Reviewed מעל שנה אחת ago