Creating database indexes for class properties (default search)
To optimize the performance of those queries that search a class property, create an index for the property in the object store database.
About this task
Restriction: If case-insensitive search behavior is in effect, do not use the
administration console to create the index for DB2® for Linux, UNIX and Windows earlier
than version
10.5.
Procedure
To create an index for a class property: