MAXIMO search type and performances differences

Type	meaning
NONE	no UI search
WILDCARD	user enter TEXT, the system uses %TEXT%; user enters =TEXT, the system uses TEXT
EXACT	user enter TEXT, the system uses TEXT, user enters TEXT%, the system will do TEXT%, if the user enters %TEXT%, the system uses %TEXT%
TEXT	ses text search - CONTAINS

For better performances it needs to avoid table scans not necessary.
So evaluate if you can change to the best performant type EXACT:

update maxattribute set searchtype = 'EXACT' where searchtype = 'WILDCARD'
update maxattributecfg set searchtype = 'EXACT' where searchtype = 'WILDCARD'