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列则不是,从而可降低开销。
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列则不是,从而可降低开销。
应用推荐