Optimizing your BigQuery Queries for Performance 2.5 Reviews

Good

Krishna Prasanth D. · Reviewed 1 yıldan fazla ago

Klever T. · Reviewed 1 yıldan fazla ago

Joey L. · Reviewed 1 yıldan fazla ago

Edward W. · Reviewed 1 yıldan fazla 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 1 yıldan fazla ago

Gyanendra-Singh R. · Reviewed 1 yıldan fazla ago

Mose O. · Reviewed 1 yıldan fazla ago

Omar Y. · Reviewed 1 yıldan fazla ago

Katayun P. · Reviewed 1 yıldan fazla ago

Jeffin K. · Reviewed 1 yıldan fazla ago

Estefania M. · Reviewed 1 yıldan fazla ago

ok

SUBHRO M. · Reviewed 1 yıldan fazla ago

Reshu G. · Reviewed 1 yıldan fazla ago

nakka n. · Reviewed 1 yıldan fazla ago

Raju S. · Reviewed 1 yıldan fazla ago

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

Caden H. · Reviewed 1 yıldan fazla ago

rajani l. · Reviewed 1 yıldan fazla ago

Fernando B. · Reviewed 1 yıldan fazla 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 1 yıldan fazla ago

fei w. · Reviewed 1 yıldan fazla ago

Ahmed T. · Reviewed 1 yıldan fazla ago

Ahmed A. · Reviewed 1 yıldan fazla ago

Carsten T. · Reviewed 1 yıldan fazla ago

Leandro S. · Reviewed 1 yıldan fazla ago

Yulia G. · Reviewed 1 yıldan fazla ago