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?
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?
ROW STORE COMPRESS ADVANCED is the best choice for OLTP environments where it is essential to compress rows for all DML statements and minimize overheads associated with compression. This option provides efficient row-level compression, which is designed to handle frequent data manipulation typical in OLTP systems, ensuring that the overhead is kept minimal while maintaining performance.
E is correct https://docs.oracle.com/database/121/ADMIN/tables.htm#ADMIN-GUID-34D15DD1-0925-4C9A-BE8A-3EE91671E526
i agree
E is correct
Advanced row compression.
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.
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;