·	Use Static Tables

·	Define Additional Indexes

·	Query Mandatory

·	Query Some Mandatory

·	Check Count Query

·	Synchronize Lookup

·	Use Screen Values

·	Optimize Joined Column Fetch

·	Remove Columns from Main Query

·	Limit Query Buffer Size