Oracle IM压缩策略
Oracle IM为了节约内存空间,并提高查询分析效率,提供如下几个压缩策略,默认MEMCOMPRESS FOR QUERY LOW。
IM Column Store Compression Methods
CREATE/ALTER Syntax | Description |
---|---|
|
The data is not compressed. |
|
This method results in the best DML performance. This method compresses IM column store data the least, with the exception of Note: This compression method is not supported for |
|
This method results in the best query performance. This method compresses IM column store data more than This method is the default when the Note: If the |
|
This method results in good query performance, and saves space. This method compresses IM column store data more than |
|
This method balances space saving and query performance, with a bias toward space saving. This method compresses IM column store data more than This method is the default when |
|
This method results in the best space saving. This method compresses IM column store data the mos |
该案例暂时没有网友评论
✖
案例意见反馈
亲~登录后才可以操作哦!
确定你的邮箱还未认证,请认证邮箱或绑定手机后进行当前操作