Searching

GoalBest Practice
Reducing the number of records to returnKeep searches specific and avoid using wildcards, if possible. For example, search with Michael instead of Mi*.
Reducing the number of joinsUse single-object searches for greater speed and accuracy.
Improving efficiencyUse 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 performanceIn some cases, partition data with divisions. (See Divisions.)
Reducing the time it takes to index inserts and updates for large data volumesSee Search Architecture.