These updates, which are all nearly automated SQL engine enhancements, include BigQuery advanced runtime, a low-latency query API, column metadata indexing, and an order of magnitude speedup for fine-grained updates and deletes in preview.
The BigQuery advanced runtime, which is currently in preview, can automatically accelerate analytical workloads, using enhanced vectorization and short query optimized mode, without requiring any user action or code changes, Google wrote in a blog post.
In order to increase query efficiency further, Google has added the BigQuery column metadata index (CMETA), which has been made generally available, that helps process queries on large tables through more efficient, system-managed data pruning.
