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.