开发者

Difference between "COMPRESS FOR ALL OPERATIONS" and "COMPRESS FOR OLTP"?

开发者 https://www.devze.com 2022-12-22 20:07 出处:网络
I was looking through Oracle\'s OLTP Table Compression (11g onwards) documentation as wel开发者_如何学运维l as online resources to find the syntax and came across two different versions:

I was looking through Oracle's OLTP Table Compression (11g onwards) documentation as wel开发者_如何学运维l as online resources to find the syntax and came across two different versions:

COMPRESS FOR ALL OPERATIONS

and

COMPRESS FOR OLTP

The documentation I looked through didn't mention any alternative syntax, so i was wondering if anyone here might know the difference.

Thank you!


COMPRESS FOR ALL OPERATIONS and COMPRESS FOR OLTP are just synonyms according to Vadzim.

On the OTN forums an oracle Ace says it's just a new name for the same thing.

http://forums.oracle.com/forums/thread.jspa?threadID=1042141&tstart=0

The same is stated here:

http://www.oracle-base.com/articles/11g/TableCompressionEnhancements_11gR1.php

COMPRESS or COMPRESS FOR DIRECT_LOAD OPERATIONS is part of the regular Oracle EE database, as stated in the PDF APC linked to.

It should be noted that Basic Table Compression is a base feature of Oracle Database 11g Enterprise Edition (EE). OLTP Table Compression is a part of the Oracle Advanced Compression option, which requires a license in addition to the Enterprise Edition.

0

精彩评论

暂无评论...
验证码 换一张
取 消