Remove Automatic Query
Prevent automatic full table queries for lookup windows.
When opening a lookup window, an automatic query is performed. Especially for large tables, this can be a drain on performance. The easiest way to get rid of automatic queries is to remove the Startup Actions setting of Lookup Windows. This setting defaults to PerformQuery().
When to use
You can use this tip on three different levels:
To prevent automatic full table queries in lookup windows: