Search Optimization

In the out-of-the-box (OOB) configuration, you do not get indexes on all the data you want to search.

After determining the common searches, determine which searches consume the maximum time. Capture the debug log for such searches and extract the query. Run the query through the database tools to determine which indexes should be created. Case-sensitive and case-insensitive searches need different indexes. You must create functional indexes to support case-insensitive searches in databases. However, indiscriminately creating indexes slows down new data acquisition.