To reduce LLM token consumption and query latency when processing large
Share
Services
## Feature
Feature
To reduce LLM token consumption and query latency when processing large datasets, enable [optimized mode](https://cloud.google.com/bigquery/docs/optimize-ai-functions)using the following [managed AI functions](https://cloud.google.com/bigquery/docs/generative-ai-overview#managed%5Fai%5Ffunctions):
* [AI.IF](https://cloud.google.com/bigquery/docs/reference/standard-sql/bigqueryml-syntax-ai-if)
* [AI.CLASSIFY](https://cloud.google.com/bigquery/docs/reference/standard-sql/bigqueryml-syntax-ai-classify)
Optimized mode supports the following:
* More types of queries are in scope for optimized mode.
* Optimized mode supports multi-label classification with `AI.CLASSIFY`.
* The **Job information** tab in the **Query results** pane shows information about the relative quality of the optimized query results.
This feature is[generally available](https://cloud.google.com/products#product-launch-stages)(GA).
## Feature
Feature
You can now use the BigQuery REST API ([datasets.insert](https://cloud.google.com/bigquery/docs/reference/rest/v2/datasets/insert),[datasets.patch](https://cloud.google.com/bigquery/docs/reference/rest/v2/datasets/patch),[datasets.update](https://cloud.google.com/bigquery/docs/reference/rest/v2/datasets/update), and[datasets.get](https://cloud.google.com/bigquery/docs/reference/rest/v2/datasets/get)) to configure and monitor [cross-region dataset replication](https://cloud.google.com/bigquery/docs/data-replication)and to attach or detach failover reservations for[managed disaster recovery](https://cloud.google.com/bigquery/docs/managed-disaster-recovery). This feature is[generally available](https://cloud.google.com/products#product-launch-stages)(GA).
## Feature
Feature
You can now use the `rerank` option in the[AI.SEARCH function](https://cloud.google.com/bigquery/docs/reference/standard-sql/bigqueryml-syntax-ai-search)to reorder the results of your search by how well the text in the column to search answers the search query. This feature is[generally available](https://cloud.google.com/products#product-launch-stages)(GA).
## Feature
Feature
You can now use the[AI.RANK function](https://cloud.google.com/bigquery/docs/reference/standard-sql/bigqueryml-syntax-ai-rank)to reorder the rows of a table by how well the text in a specified column answers a search query. This function is[generally available](https://cloud.google.com/products#product-launch-stages)(GA).