The DBMS_ASYNC_INDEX system package is used to manage asynchronous indexes and provides an interface for manually triggering a major compaction. It applies to tables that have created asynchronous full-text indexes (ASYNC FULLTEXT) or asynchronous search indexes (ASYNC SEARCH INDEX).
Note
This system package is supported starting from V4.6.2.1.
Overview of the DBMS_ASYNC_INDEX Subprogram
The following table lists the DBMS_ASYNC_INDEX subprograms supported by the current version of OceanBase AI Database and provides brief descriptions.
Subprogram |
Description |
|---|---|
| FORCEMERGE | Manually trigger a major compaction for asynchronous indexes on a specified table. |
References
- For more information about the features, table-level parameters, and examples of asynchronous full-text indexes, see the "Asynchronous Full-Text Indexes" section in Full-text search.
- For more information about the asynchronous search index feature, see the "Asynchronous search index" section in Search index.