Suppose you are tasked with creating a query to extract sales data from a database with multiple forms and reports. what should you prioritize to ensure the query runs smoothly and provides accurate results?
- Maximizing the number of fileds in the query
- Optimizing the query with indexed fields and simple conditions
- Deleting unused forms before running the query
- avoiding the use of macros the database
