BigQuery repeated fields query optimization.

Table repeated column summary
The second query execution timeline
The third query execution timeline
The third query execution timeline on 500 slots reservation pool

Data indexing

Master repeated table enriched with batch_id and seq.
Indexing int value table template
the repeated table extract
Bitsy indexing rule in YAML format
Rewritten query with the bitset index.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store