You want to use table compression suitable for OLTP that will: 1. Compress rows for all DML statements on that table 2. Minimize the overheads associated with compression Which compression option is best suited for this?
my answer: E
-> compress rows for all DML statementsc+ lower overheads than Hybrid Columnar Compression
the others:
B. ROW STORE COMPRESS BASIC: false, not works for all DML statements, e.g. updated rows are not compressed
A, C, D: false due to higher overheads
E option is right:
“ROW STORE COMPRESS ADVANCED”. See the example below:
CREATE TABLE emp (emp_id NUMBER, first_name VARCHAR2(128), last_name VARCHAR2(128)) ROW STORE COMPRESS ADVANCED;
https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-TABLE.html#GUID-F9CE0CC3-13AE-4744-A43C-EAC7A71AAAB6 When you enable table compression by specifying ROW STORE COMPRESS ADVANCED, you enable Advanced Row Compression. Oracle Database compresses data during all DML operations on the table. This form of compression is recommended for OLTP environments.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
avanand
Highly Voted 4 years, 4 months agoEkos
4 years agocseko76
Most Recent 2 months, 2 weeks agovaliantvimal
8 months, 2 weeks agonautil2
1 year, 3 months agoauwia
1 year, 6 months agoryuah
3 years ago