Query performance can be improved, sometimes significantly, by setting the size of the main buffer cache smaller than the calculated recommended value in Sybase IQ Administration and Performance Guide. The reasons for this are described in “Using the NTFS cache”.
You may also improve performance by making the temp buffer cache smaller. Be careful in a multiuser environment, however, because reducing the size of the temp buffer cache impacts the various page pinning and sort algorithms which, in turn, may degrade performance.
