The following script can be edited and run on your warehouse database to generate a script to enable row compression across all AW created fact tables.
以下脚本可被编辑并在您的数据仓库数据库上运行,来生成一个脚本跨所有 AW 创建的事实表启动行压缩。
In this example, an typical ERP database was backed up with the compression option.
在这个例子中,我们使用压缩选项备份了一个典型的ERP数据库。
Also, database cannot be sized based on this compression ratio as was mentioned in the keynote - it needs extra space for various technical reasons.
还有,在宣讲会上提过,数据库不能根据这个压缩比来衡量大小——由于技术原因它还需要额外的空间。
应用推荐