BLEND BYTES 1: Speed up sql queries with Bigquery
SQL Query taking too long?
Are frustrating, slow databases holding you back?
When working with BigQuery, especially at the beginning, it is common to trip up on queries. You may write a query that uses more compute resource, or takes up more time than necessary for example.
This can be tedious, and the quicker you can learn to optimize your querying, the more efficiently you can do your data analysis!
So, here are three easy SQL tips for optimizing performance (see video for how to do this!)
Avoid SELECT * - Instead of selecting all columns, query only the necessary columns to reduce the amount of data the database needs to retrieve and process.
Utilize WHERE Clauses - Always filter data using WHERE clauses to limit the number of rows the database needs to scan, reducing the overall query time.
Use ORDER BY - The amount of times we see database tables that don't order data to make it easy to read is unbeliveable - and it saves so much time!
Follow Blend: Data Analysts & Business Strategists to get these videos first!