CheckIvaraIndexes loops through oq.omsystem to retrieve all the DBDomains to call CheckSystemIndexes.
The oq.CheckSystemIndexes will be called for the following schema:
OQ
DistributorData
CustomerData
IFW
FND
MNT
MAT
PRO
IVTEST
IVSTAGE
EXD
INTOP
‘exec oq.checkivaraindexes 1’ is for creating the indexes
‘exec oq.checkivaraindexes 0’ is to display the indexes that are missing (debug)
So you can avoid calling the oq.CheckSystemIndexes manually so you don’t miss any of the systems above.