DB 2行压缩功能可以减少磁盘存储需求,同时改进执行全表扫描的大量查询的顺序读取访问。
DB2 row compression features can decrease disk storage requirements while at the same time improve sequential read access of large queries which perform full table scans.
通常来说,您可能只希望获得表中数据的一个子集,因此全表扫描会浪费大量的磁盘 I/O,因此也就会浪费大量时间。
Most often, you want only a small subset of the data in the table, so a full table scan wastes a lot of disk I/O and therefore time.
这个报表查询需要该事实表的一个全表扫描。
This report query requires a full table scan of the fact table.
应用推荐