You may also improve query performance by reducing the size of the main and temp buffer caches as described in the previous paragraph. Be careful in a multiuser environment, however, because reducing the size of the temp buffer cache affects the various page pinning and sort algorithms which, in turn, may degrade performance. See Chapter 3, “Optimizing Queries and Deletions,” for details about query plans, structure, and options.
