You archive purchase orders on a quarterly basis. For example, you archive purchase orders with transaction dates between September, 1 2010, and December 31, 2010. You regularly run queries to find purchase orders on a specific date, such as December 24, 2010. When you run queries, the query performance is slow. The query statistics log shows that the query processes a majority of the data files. In addition, the query consumes a large amount of resources.