These updates, that are all practically 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 robotically speed up analytical workloads, utilizing enhanced vectorization and quick question optimized mode, with out requiring any consumer motion or code adjustments, Google wrote in a weblog publish.
As a way 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 means of extra environment friendly, system-managed knowledge pruning.
