What are the best practices for optimizing the performance of a query that returns a small result set from a very large table?