JSON Search Index Maintenance
Oracle Health Insurance applications make use of JSON Search Indexes. These indexes require regular maintenance. The following table lists the JSON Search Indexes per the Oracle Health Insurance application:
Oracle Health Insurance Application | JSON Search Index |
---|---|
Oracle Health Insurance Authorizations |
OHI_REF_SHEET_LINE_IDX1 |
Oracle Health Insurance Value-Based Payments |
OHI_REF_SHEET_LINE_IDX1 |
Claims |
OHI_REF_SHEET_LINE_IDX1 |
Policies |
OHI_REF_SHEET_LINE_IDX1 |
Oracle Insurance Gateway |
OIG_EXCHANGE_IDX1 |
Oracle Health Insurance Product Definition |
OHI_REF_SHEET_LINE_IDX1 |
Oracle recommends to set up a scheduled job in the database to regularly optimize the index using the OPTIMIZE_INDEX procedure (see the Oracle Database documentation for details).