Search option configuration for performance optimization
You want to prevent users from performing queries that
retrieve hundreds of thousands of records. You should periodically
review users saved queries, you could define default queries for your
users, or educate them on how to create efficient queries
Text search function
The text search function uses SQL to index, search, and
analyze text and documents that are stored in system databases. You
can search for information based on text, content metadata, or attributes.
Search type configuration
By setting search types for database columns, you can improve
the results that are returned by user queries. Setting the search
type can also reduce the load on the database.