Como otimizar suas consultas do BigQuery para um melhor desempenho 2.5 avaliações

Good

Krishna Prasanth D. · Revisado há over 1 year

Klever T. · Revisado há over 1 year

Joey L. · Revisado há over 1 year

Edward W. · Revisado há over 1 year

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

Tim W. · Revisado há over 1 year

Gyanendra-Singh R. · Revisado há over 1 year

Mose O. · Revisado há over 1 year

Omar Y. · Revisado há over 1 year

Katayun P. · Revisado há over 1 year

Jeffin K. · Revisado há over 1 year

Estefania M. · Revisado há over 1 year

ok

SUBHRO M. · Revisado há over 1 year

Reshu G. · Revisado há over 1 year

nakka n. · Revisado há over 1 year

Raju S. · Revisado há over 1 year

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

Caden H. · Revisado há over 1 year

rajani l. · Revisado há over 1 year

Fernando B. · Revisado há over 1 year

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. · Revisado há over 1 year

fei w. · Revisado há over 1 year

Ahmed T. · Revisado há over 1 year

Ahmed A. · Revisado há over 1 year

Carsten T. · Revisado há over 1 year

Leandro S. · Revisado há over 1 year

Yulia G. · Revisado há over 1 year