Making Searches Case-insensitive

By default, Search queries are case-sensitive for full-text searches and field-based ones. You can modify the database to make Search insensitive to case.

As the dbadmin user in the ArcSight Database, execute the following command:

 – ALTER DATABASE investigate set DefaultSessionLocale = ‘en_ US@colstrength=secondary’
Case-insensitive searches tend to slow Search performance.