下面的例子展示如何创建采用压缩的分区表。
The following example shows how to create partition table with compression.
此外，只有当物理表数据对象或分区中没有压缩字典时，才能运行adc。
Additionally, ADC only occurs if no compression dictionary exists within the physical table data object or partition.
压缩减少所存储数据的大小，从而在分区中生成未使用的空间。
Compress reduces the size of data being stored, thereby creating unused space in the partition.
DB 2提供了压缩一个表空间或分区中的数据的能力。
DB2 provides the capability to compress the data in a table space or partition.
数据中的模式：对于特定的表空间或分区，数据中重复出现的模式的出现频率将决定压缩的效果。
Patterns in the data: the frequency of recurring patterns in the data determines how effective compression will be for a particular table space or partition.
它可以用于压缩整个表、表分区和物化视图。
It can be used to compress entire tables, table partitions, and materialized views.
注意，分区表的每个分区可以有不同的压缩词典，在DPF中一个表的每个分区也可以有不同的压缩词典。
Note that each partition of a partitioned table can have a different compression dictionaries and each partition of a table in DPF can have a different compression dictionaries.
压缩可应用于所有分区或部分分区。
The compression can be applied to all partitions or some partitions.
如果表是一个范围集群表(不支持行压缩)，可以考虑将其变换为范围分区表(支持行压缩)。
If the table is a range clustered table (that does not support row compression), you can consider switching it to become a range partitioned table (that supports row compression).
为了获得更好的性能和最小化空间消耗，我们建议使用数据库分区、范围分区、压缩和多维集群。
For best performance and minimal space consumption, we recommend using database partitioning, range partitioning, compression, and multi-dimensional clustering.
在决定是否压缩一个表空间或分区时，要考虑下面一些事情。
Here are some things to consider when trying to decide whether or not to compress a table space or partition.
企业版通过高级审计和透明数据加密功能为其增加了更高的安全性，还添加了拥有ColumnStore的数据仓库、压缩、以及分区。
The Enterprise edition adds more security through advanced auditing and transparent data encryption, and data warehousing with ColumnStore, compression, and partitioning.
由于数据分散的原因，当Fours quare试图增加一个分区时没有成功，需要数据库离线才能对数据进行压缩。这也导致了系统宕机时间的延长。
The system outage was prolonged when an attempt to add a partition didn't work due to fragmentation, and required taking the database offline to compact it.
切分的好处（如分区一样）在于它可以压缩大型数据：单独的数据表在每个切分中相对较小，这样就可以支持更快速的读写速度，从而提高性能。
The benefit of sharding (like partitioning) is that it compacts big data: individual tables are smaller in each shard, which allows for faster reads and writes, which increases performance.
你可以为表空间，表或者一个分区指定压缩。如果指定为表空间基本，那么该表空间所有表创建后默认都启用压缩。
You can specify compression for a tablespace, a table, or a partition. If specified at the tablespace level, then all tables created in that tablespace are compressed by default.
因此，压缩、重新打包、和收缩可能会像碎片整理程序一样，能够减少分区总的区段数量。
So compress, repack, and shrink might be able to reduce the total number of extents for a partition, just like the defragmenter.
你可以为表空间，表或者分区指定压缩属性。如果你为表空间指定了压缩属性，那么在该表空间下建的表会默认的继承压缩属性。
You can specify compression for a tablespace, a table, or a partition. If specified at the tablespace level, then all tables created in that tablespace are compressed by default.
一个分区表可以同时包含压缩的和非压缩的分区，并且可以给压缩分区指定不同的压缩方式。
A table can have both compressed and uncompressed partitions, and different partitions can use different compression methods.
显示或改变NTFS分区上文件的压缩。
COMPACT Displays or alters the compression of files on NTFS partitions.
警告：这会把你分区里所有文件替换成压缩文档里的文件！
WARNING: this will overwrite every single file on your partition with the one in the archive!
你可以创建一个压缩索引，或者重建时压缩一个索引(尽管对在线重建、重建分区索引等有一些限制)。
You can create an index as compressed, or rebuild it to compress it although there are some restrictions about online rebuilds, rebuilds of partitioned indexes etc.
一次操作即可解压缩一个分区中所有压缩的NTFS文件，优化系统性能。
Decompress all compressed NTFS files on a drive in a single operation. Optimize system performance.
研究了压缩天然气加压站或加气站储气库储气容积分区的原理，指出分区的意义。
The principle on partition of storage volume in reservoir for compressed natural gas (CNG) pressure station or fueling station is studied, and the meaning of partition is pointed out.
方法：将新鲜颞下颌关节盘分区围限压缩，在不同时间观察其扫描电镜表现。
Methods: the confining indentation was used on different areas of the cadaver TMJ discs.
方法：将新鲜颞下颌关节盘分区围限压缩，在不同时间观察其扫描电镜表现。
Methods: the confining indentation was used on different areas of the cadaver TMJ discs.
应用推荐