如果排序的性能在您的环境中很重要,那么需要为工作文件创建一个单独的缓冲池。
If the performance of sorts is important in your environment, then create a separate buffer pool for work files.
这将指示DB 2将索引键传递给内存中的排序程序,而不是再次将这些键写到DASD上的排序工作文件中,然后从中读取这些键。
This instructs DB2 to pass the index keys to the sort program in memory, rather than having the keys written to and read once again from sort work files on DASD.
这将指示DB 2将索引键传递给内存中的排序程序,而不是再次将这些键写到DASD上的排序工作文件中,然后从中读取这些键。
This instructs DB2 to pass the index keys to the sort program in memory, rather than having the keys written to and read once again from sort work files on DASD.
应用推荐