Searching

Goal Best Practice
Reducing the number of records to return Keep searches specific and avoid using wildcards, if possible. For example, search with Michael instead of Mi*.
Reducing the number of joins Use single-object searches for greater speed and accuracy.
Improving efficiency Use the setup area for searching to enable language optimizations, and turn on enhanced lookups and auto-complete for better performance on lookup fields.
Improving search performance In some cases, partition data with divisions. (See Divisions.)
Reducing the time it takes to index inserts and updates for large data volumes See Search Architecture.