Explore >> Select a destination
|
You are here 
|
minhajuddin.com | ||
| | | | |
ctoomey.com
|
|
| | | | | ||
| | | | |
saeedesmaili.com
|
|
| | | | | I came across this Linkedin post from a Google engineer, on a new (in preview) and very interesting BigQuery syntax: GROUP BY ALL. This will save time when writing and specially modifying complex SQL queries on BigQuery. The GROUP BY ALL clause groups rows by inferring grouping keys from the SELECT items. It will exclude expressions with aggregate and window functions, constants, and query parameters for a smart GROUP BY. So instead of GROUP BY name, city, device, browser, date or GROUP BY 1, 2, 3, 4, 5 you would use GROUP BY ALL. | |
| | | | |
explainextended.com
|
|
| | | | | A late row lookup requires that the engine looks up a row in a table only if it had not been filtered by the index. MySQL is not capable of doing this but this can be emulated. It improves the LIMIT performance and filtering efficiency on the indexed fields | |
| | | | |
timilearning.com
|
|
| | | Notes from Chapter 9 of Martin Kleppmann's 'Designing Data-Intensive Applications' book. | ||
