Index Maintenance

Rebuild Indexes

Rebuilding an index is the process of recreating it “from scratch." The following indexes can be rebuilt for IPRO cases:

  • Full-text (Words and phrases in the indexed fields. All text fields are indexed by default.)

  • Transcripts associated with a case

  • Sticky Notes or Embedded Text added to images

To fully rebuild one or more indexes:

  1. Getting started:

    1. Select an appropriate time to rebuild your indexes.

      Depending on the size of the database, system capabilities, and other factors, global functions may consume significant system resources and time. It is recommended that you carry out major global functions during “off hours” to minimize the impact to the system and your users.

    2. If users might be logged on, alert them that performance may be affected while you rebuild the indexes. You may also require that users log off, depending on the size and complexity of your databases.

  2. On the Local Dashboard, expand the Utilities menu in the top, far-left corner of the screen. Select the Case Utilities button from that menu to open the application in a new window.

  3. In the Case Utilities workspace, select the case(s) for which indexes are to be rebuilt.

  4. On the Rebuild Index tab, select the indexes to be rebuilt, then click Rebuild. Observe status on the bottom of the workspace.

Flush an Index

Over time, database changes cause indexes to become fragmented. Flushing an index condenses/optimizes the index for improved performance.

To flush one or more case indexes:

  1. Getting started:

    1. Select an appropriate time to rebuild your indexes.

      Depending on the size of the database, system capabilities, and other factors, global functions may consume significant system resources and time. It is recommended that you carry out major global functions during “off hours” to minimize the impact to the system and your users.

    2. If users might be logged on, alert them that performance may be affected while you flush the indexes. You may also require that users log off, depending on the size and complexity of your databases.

  2. On the Local Dashboard, expand the Utilities menu in the top, far-left corner of the screen. Select the Case Utilities button from that menu.

  3. In the Case Utilities workspace, select the case(s) for which indexes are to be flushed.

  4. Click the Flush Index tab and choose the needed indexes:

    • Document Full Text Index

    • Sticky Notes Index

    • Embedded Text Index

  5. Click Flush and observe status on the bottom of the workspace.

 

Related Topics

Overview: Case Utilities