SEARCH_OPTIMIZATION_HISTORY views: New columns and column changes (Pending)

Attention

This behavior change is in the 2026_06 bundle.

For the current status of the bundle, refer to Bundle history.

When this behavior change bundle is enabled, the SEARCH_OPTIMIZATION_HISTORY views in the Account Usage and Organization Usage schemas, and the output of the SEARCH_OPTIMIZATION_HISTORY table function in the Information Schema, are updated so you can distinguish maintenance costs for search optimization indexes from secondary indexes.

Before the change:
  • The views and table function report maintenance history for search optimization only. Secondary index maintenance does not appear.
  • The TABLE_ID column identifies the search optimization service instance.
  • The TABLE_NAME column is a system-generated alias of the form SEARCH OPTIMIZATION ON TABLE_ID: <base_table_id> that references the base table on which search optimization is enabled.
After the change:
  • Secondary index maintenance appears in the views and table function.
  • The TABLE_ID and TABLE_NAME columns are replaced with index-level and base-table metadata columns (see the following table).
  • The new INDEX_TYPE column labels each row as Search Optimization Index or Secondary Index.
  • The INDEX_NAME column identifies the index:
    • For a search optimization index, shows the alias SEARCH OPTIMIZATION ON: <base_table_id>.
    • For a secondary index, shows the customer-defined index name.

Account Usage and Organization Usage views

When this behavior change bundle is enabled, the Account Usage and Organization Usage SEARCH_OPTIMIZATION_HISTORY views include the following new columns and column changes:

Column nameData typeDescription
BASE_TABLE_IDNUMBERInternal/system-generated identifier for the base table.
BASE_TABLE_NAMEVARCHARName of the base table.
INDEX_IDNUMBERInternal/system-generated identifier for the specific index. Replaces TABLE_ID.
INDEX_NAMEVARCHARName assigned to the index or the search optimization reference. Replaces TABLE_NAME.
INDEX_TYPEVARCHARType of index maintained. Possible values include Search Optimization Index and Secondary Index.

If you have automated scripts or BI tools that query these views or the table function and rely on the TABLE_ID or TABLE_NAME columns, update your queries to use the new column names before the bundle is enabled.

Ref: 2384