Indexes can vastly increase query performance in Maximo but it can also add overhead to CPU and database. As each update / insert / delete will cause the index to be updated too.
Creating index in Maximo in pretty straight forward.
Procedure:
In database configuration application, select the object you want to create index on.
The indexes tab shows the list of indexes as well as the columns in that index.
e.g. I have a column
STATUS in my object. To enable indexing on that click on new row.Enter the unique name for that index e.g.
SLASTATUSEnforce Uniqueness: To make sure only unique values can be inserted in that field. Check the Enforce Uniqueness button. The existing data in that column must already be unique
Clustered Index: DB2 and Microsoft SQL server supports this option. When checked, it will enable clustering which will define the logical order to store data. Hence, much better ordered search performance. However, only one clustered index can be created on a table. The attributes you enable this feature must be unique.
Text Search Index: This should be enabled on attributes which has lots of text in them. It puts overhead on DB because of continuous use of updating and synchronizing these index in background
Internal: Some built in indexes have internal checked. They are for maximo internal system use and should not be altered
In the columns view below.
- Add the columns you want to be indexed. Save
- Configure DB
This does not require Admin mode to be turned on