Without file system caching, Q1 performs similarly on XML and CLOB columns, with a slight disadvantage (10%) for the CLOB column which is not buffered in the buffer pool.
在没有文件系统缓存的情况下，XML和clob列的Q1执行效果类似，不在缓冲池进行缓冲的clob列略微落后(10%)。
Without file system caching, this overhead is mitigated by the fact that XML columns are buffered in the DB2 buffer pool and CLOB columns are not.
在没有文件系统缓存的情况下，xml列在db2缓冲池进行缓冲而clob列则不是，从而可降低开销。
应用推荐