How do I control query options (number of rows, etc)?

When viewing your query in Edit Query mode you can use the Properties tab to select just a sample data set, opt not to retrieve duplicates, alter the order of prompts, and control other options about the query itself. (see below)