它允许使用64位数据源驱动程序,且可以利用64位满足查询处理、元数据缓存和数据缓存的空间。
It permits the use of 64 bit data source drivers and can leverage the 64 bit address space for query processing, metadata caching and data caching.
所以这样做时要小心,不过,太多的自由空间意味着大量的索引页,这对查询的性能乃至 insert 处理本身都会产生负面影响。
This must be done carefully, however, because too much free space will mean an abundance of index pages, which could negatively impact query performance and even insert processsing itself.
此外,DB 2提供了先进的SQL功能来帮助处理复杂的查询,包括地理空间数据和复杂计算。
In addition, DB2 provides advanced SQL features to help handle complex queries, including geospatial data and complex computations.
应用推荐