If you compress more columns than you should, the 'compressed' index may be larger than the uncompressed index.
如果压缩了过多的列,“压缩”了的索引可能比未压缩的索引更大。
Indexes that can be compressed are bitmap, btree and index organized tables.
可以压缩的索引有bitmap、btree和索引组织的表。
An index set with compress YES is compressed when the index is created.
设置了COMPRESSYES的索引在创建时就进行压缩。
An altered index cannot be compressed until the index is reorganized or rebuilt.
不对变更的索引进行压缩,直到该索引被重组或重构。
In the paper storage models based on relation database, object-oriented database, index files, compressed files are discussed in detail.
文中对基于关系数据库、面向对象数据库、索引文件、压缩文件的存储模型进行了详细地论述。
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.
你可以创建一个压缩索引,或者重建时压缩一个索引(尽管对在线重建、重建分区索引等有一些限制)。
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.
你可以创建一个压缩索引,或者重建时压缩一个索引(尽管对在线重建、重建分区索引等有一些限制)。
应用推荐