- Schema:
SEARCH_
The SEARCH_OPTIMIZATION_HISTORY view in the ORGANIZATION_USAGE schema is used for querying the search optimization service maintenance history for a specified table within a specified date range. The information returned by the function includes the table name and credits consumed each time a search optimization maintenance operation occurred.
Columns¶
| Column Name | Data Type | Description |
|---|---|---|
| ORGANIZATION_NAME | VARCHAR | Name of the organization where the usage took place. |
| ACCOUNT_NAME | VARCHAR | Name of the account where the usage took place. |
| ACCOUNT_LOCATOR | VARCHAR | Name of the account locator. |
| REGION | VARCHAR | Name of the region where the account is located. |
| USAGE_DATE | DATE | Date (in the UTC time zone) of this usage record. |
| CREDITS_USED | NUMBER | Number of credits billed for the search optimization service during the USAGE_DATE. |
| TABLE_ID | NUMBER | Internal/system-generated identifier for the search optimization service. |
| TABLE_NAME | VARCHAR | This is a system-generated alias that contains the ID of the table for which search optimization was enabled; that ID is embedded inside a string of the form “SEARCH OPTIMIZATION ON TABLE_ID: <optimized_table_id>”. For example, if you enable search optimization on a table named accounts, and if accounts has ID 1200, then the TABLE_NAME (alias) shown in this column will be “SEARCH OPTIMIZATION ON TABLE_ID: 1200”. |
| SCHEMA_ID | NUMBER | Internal/system-generated identifier for the schema that contains the search optimization service. |
| SCHEMA_NAME | VARCHAR | Name of the schema that contains the search optimization service. |
| DATABASE_ID | NUMBER | Internal/system-generated identifier for the database that contains the search optimization service. |
| DATABASE_NAME | VARCHAR | Name of the database that contains the search optimization service. |
Usage notes¶
- Latency for the view may be up to 24 hours (1 day).