这道题关于行压缩和页压缩
谁是谁的谁 2011-12-04 10:30:32 You administer a SQL Server 2008 infrastructure.
You partition the largest table in a database into four equal-sized parts. The first two partitions are rarely queried. The third partition is frequently queried by several reports. The last partition is heavily queried and frequently modified.
You need to minimize the disk space of the table and ensure that this has minimum effect on the query
performance.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
你管理一个SQL Server2008基础设施。
你在数据库中最大的表分为四个大小相等的分区。前两个分区都很少查询。第三个分区是频繁查询的几份报告。最后一个分区是大量查询,并经常修改。
您需要尽量减少表的磁盘空间,并确保这对查询性能的影响最小。
你应该执行哪两个动作? (每个正确的答案,提出解决方案的一部分,选择两个。)
A. Enable ROW compression for the last partition.
B. Enable ROW compression for the third partition.
C. Enable ROW compression for the first two partitions.
D. Enable PAGE compression for the last partition.
E. Enable PAGE compression for the third partition.
F. Enable PAGE compression for the first two partitions.
标准答案是BF
我想弄清楚的是到底什么情况下用行压缩,什么情况下用页压缩?