Unlike other compression techniques that scan only a portion of each row for repeating patterns, Storage Optimization scans the entire row, regardless of how many columns it intersects.
其他压缩技术只在每行的一部分中寻找重复模式,而Storage Optimization会扫描整个行,无论行中有多少列。
The entire fact table is read if all dimension table joins are removed by this optimization.
如果所有的维度表连接被该优化移除,则会读取全部事实表记录。
Query Options File (QAQQINI) — the OPTIMIZATION_GOAL option can be specified with one of the following values to control the optimization goal for the entire system or a specific connection (job).
Query Options File (QAQ QINI)——可以通过将OPTIMIZATION _ GOAL选项指定为以下几个值之一,来控制整个系统或一个特定连接(任务)的优化目标。
应用推荐