Development > Utilities > Verifications > Database > Search index 

Ergonomics | Index

Sometimes for operational reasons, certain indexes of the Adonix X3 database are not created properly in a given folder. This may be the case, for example, if there is not enough space at a given time in the temporary table space under Oracle -- either when revalidating a folder, or when changing a table structure. From the database domain, these production errors trigger error log files, which should warn the person using the database.

Such errors do not prevent the ADONIX X3 software from working, but they may result in serious response time problems. Also, this utility was designed to be used to verify, in the case of a response time degradation, that the required indexes are actually there.

The tests made are the following:

First, check that the indexes described in the X3 data dictionary, (this is the principal test, and it is the result of this test that is important) and not disabled through an activity code, are actually present in the database.

in addition, the list of the indexes that exist without being described in the data dictionary must be provided. This list is not normally empty, but it does not cause problems in terms of response time. For example, found here are the tables arising from a previous major version of the Adonix X3 that have not been deleted automatically for security reasons, or table indexes de-activated by means of an activity code (in this case the table is created empty).

finally indexes where the name does not conform to the naming rules used by ADONIX (an index is called NOMTABLE_NOMINDEX) may be found. These indexes can be used perfectly well by other programmes directly accessing the database.

This utility, which creates a log file, works with both the Oracle database and the SQLserver database. It automatically determines the current database type and identifies it in the log file.