.../size][/quote] 如果MAX的时候要整列所有数据都要扫描的,除非在该建上有显著的INDEX,否则会执行TABLE FULL ACCESS(全表扫描)增加很多IO成本降低服务器的性能,如果此时刚好数据库执行INSERT,UPDATE等事务的并发超做将会导致锁表。
基于1个网页-相关网页
Table Access Full 全表扫描
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.
DB 2行压缩功能可以减少磁盘存储需求,同时改进执行全表扫描的大量查询的顺序读取访问。
It's also optimized for full table scans (one of the most common-and most time-consuming-business intelligence query access patterns).
它还针对完全表扫描(一个最常见—也最耗时—的商业智能查询访问模式)进行了优化。
After the table is redistributed (the table goes back to the normal state), you are required to take a tablespace level backup in order to acquire full access to the table again.
在这个表被重分发之后(回到正常状态),需要进行一个表空间级的备份,以便重新获得对该表的全部访问权。
应用推荐