|
OMNIDEX Indexing |
Index Maintenance |
Changing an Index Installation
Index Maintenance
|
Index MaintenanceMaintaining Omnidex indexes is done in several ways and varies depending on the application. It is important to remember that creating Omnidex indexes is a two step process: installing and building. Each step is a completely separate process that must be completed in order to gain the benefits provided with Omnidex. Both steps do not necessarily have to be done together. However, the indexes must be installed prior to building them. After the indexes have been installed and built, they must be maintained, updated as the underlying data is updated. Omnidex provides three options for this type of maintenance, all of which are discussed in Updating the Indexes.
Changing an Index InstallationWhen adding, deleting or changing an index or its options, the indexes must be reinstalled and rebuilt. In this situation, an installation batch file is invaluable. Edit the installation batch file from the original installation to reflect the current changes then run the new batch installation. This saves time and reduces the possibility of error. Remember to reindex all domains and ASK indexes after the installation is changed.
|
|
Indexing Options | Indexing Strategies | Index Maintenance | Optimization | DBINSTAL |
ASK Indexes |
MDK Indexes |
Composite Indexes |
Bitmap Indexes |
Excluded Words |
Translation Table |
Special Characters |
Domains |
Omnidex IDs by Domain |
Sorted Multi-Find |
Installing the Indexes |
Building the Indexes |
Updating the Indexes |
ODXAIM |
The Explain Plan |
Nested Queries |