Learn extra at:
These updates, that are all almost automated SQL engine enhancements, embrace BigQuery superior runtime, a low-latency question API, column metadata indexing, and an order of magnitude speedup for fine-grained updates and deletes in preview.
The BigQuery superior runtime, which is presently in preview, can routinely speed up analytical workloads, utilizing enhanced vectorization and quick question optimized mode, with out requiring any consumer motion or code modifications, Google wrote in a weblog publish.
So as to enhance question effectivity additional, Google has added the BigQuery column metadata index (CMETA), which has been made usually accessible, that helps course of queries on giant tables by extra environment friendly, system-managed information pruning.
