|
OMNIDEX Indexing |
Index Maintenance |
|
Installing the IndexesAfter designing the index installation, use the Omnidex utility, DBINSTAL, to install the indexes onto the environment catalog. This step must be performed prior to building the indexes.
If the installation has changed, you may want to do the installation manually and then generate a new script file for future updates, rather than trying to modify and existing script. Any errors in the script will cause the installation to fail. To install the indexes manually, run DBINSTAL from a system prompt and follow the screen prompts: > dbinstal To use an installation script, run DBINSTAL from a system prompt and pass the installation script as a command line argument: > dbinstal < install.in
Periodic UpdatesFrom time to time, it may be necessary to reinstall the indexes. For example, when upgrading Omnidex to a newer version. In this case, you will need to recompile the environment catalog and reinstall the indexes. If upgrading Omnidex to a new "Major" version, 3.8 to 4.1 for example, or if the index installation changed, it may not be necessary to rebuild the indexes. |
|
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 |