压缩索引会提高性能么？
压缩索引会提高性能么？
压缩索引已经存在好几年了——那么压缩索引会自动提高性能么？
Compressed indexes have been around for a couple of years now - but will compressing your indexes automatically improve performance?
对于不是在内部用压缩特性创建的索引，可以通过修改它们将它们转换成压缩索引。
For indexes that were not created initially with compression, you can turn them to compression by altering them.
DB 2 9.7不仅压缩行数据；它还可以压缩索引、日志文件、临时表、内联xML数据和大对象。
DB2 9.7 compresses more than just row data; it can also compress indexes, log files, temporary tables, inline XML data, and large objects.
你可以创建一个压缩索引，或者重建时压缩一个索引(尽管对在线重建、重建分区索引等有一些限制)。
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.
该加速器然后访问这些表而不压缩数据，所以您没有索引开销。
The accelerator then accesses these tables without uncompressing data, so you don't have index overhead.
XML数据和索引的压缩，这会改进某些工作负载的存储效率和运行时性能。
Compression of XML data and indexes, which improves storage efficiency and runtime performance for certain workloads.
在线执行索引重组，并在发生表重组时重构压缩字典。
Perform index reorganizations online and rebuild compression dictionaries when table reorganization takes place.
新的XML数据和索引压缩支持可以减少所需的磁盘空间，可以提高受I/O 限制的操作的运行时性能。
New compression support for XML data and indexes reduces disk space requirements and can improve runtime performance of I/O-bound operations.
索引负载将开始减少，并且您将看到一个优秀的压缩率。
Index overhead would start to reduce, and you would see a good compression rate begin to materialize.
可以在压缩文档上构建xml索引技术，构建方式与在常规XML文档上构建它们的方式相同。
XML indexing techniques can be built on the compressed document in a similar manner to those that can be built on regular XML documents.
这些冲突操作包括：压缩、重新打包、收缩、更改、在线索引构建、截断、以及删除。
These conflicting operations include: compress, repack, shrink, alter, online index build, truncate, and drop.
不对变更的索引进行压缩，直到该索引被重组或重构。
An altered index cannot be compressed until the index is reorganized or rebuilt.
多维集群(V 8GA)：使用块索引，数千个记录共用一个索引条目，实现索引压缩。
Multidimensional Clustering (V8 GA) : Implements a form of index compression by using block indexes, one index entry for thousands of records.
在DB 2 9.5中，添加了自动字典创建，所以不再需要自行构建字典；在DB 2 9.7中，索引和临时表现在可以压缩。
In DB2 9.5, automatic dictionary creation was added so you no longer had to deal with building a dictionary yourself; in DB2 9.7, indexes and temporary tables can now be compressed.
DB 2 9.7中的新技术还可以压缩关系和xml索引。
New technology in DB2 9.7 also enables relational and XML indexes to be compressed.
实际上，在默认情况下，在压缩的表上创建的索引本身也是压缩的。
Indeed, indexes created over compressed tables are themselves compressed by default.
使用XML数据和索引压缩提高存储效率和性能。
Exploring XML data and index compression for storage efficiency and performance.
可以压缩的索引有bitmap、btree和索引组织的表。
Indexes that can be compressed are bitmap, btree and index organized tables.
此外，DeepCompression则被用于压缩表和索引数据。
In addition, Deep Compression was used to compress both table and index data.
Oracle从版本8i开始就引入了索引压缩。
虽然通过压缩应用程序和运行updall任务来刷新视图索引是很好的数据库实践，但这些做法通常不会提高应用程序的性能。
While compacting your applications and running the updall task to refresh view indexes are good database practices, they will generally not improve your application performance.
减小邮件文件的大小可以提高视图索引编制、压缩、备份还原和事务日志记录的性能。
Reducing mail file size improves performance of view indexing, compact, backup and restore, and transaction logging.
设置了COMPRESSYES的索引在创建时就进行压缩。
An index set with compress YES is compressed when the index is created.
提出了一种高效的变长索引压缩算法。
重新组织索引时，除了重新组织一个或多个索引外，默认情况下还将压缩聚集索引或基础表中包含的大型对象数据类型(lob)。
Besides reorganizing one or more indexes, large object data types (LOBs) that are contained in the clustered index or underlying table are compacted by default when an index is reorganized.
该系统具有视频压缩、解码、网络传输、图像储存、图像索引回放、摄像机远程控制、云台控制和音频报警等功能。
This system had functions with video compression, decode, network transmission, image store, image index playback, long-range control of vidicon, PTZ control and voice frequency alarm.
提出了一个基于数据压缩的全文本数据库倒排索引结构，并在此结构上设计出了一些查找算法来获得更好的查找性。
Based on data compression, a inverted index structure in full textual databases is proposed, and some search algorithms on the index are designed to obtain better performance.
如何在压缩域进行镜头的切变检测一直是视频自动索引和检索中的难点。
Shot cut detection is one of the challenging problems in video auto-index and retrieval.
应用推荐