You have been asked to use table compression for two large tables. Given are the details of the tables:
The TRANS_DET table:The table is used by an OLTP application.
High volume insert and update operations are performed on the table.
The table is frequently queried using index range scans.
The TRANS_HISTORY table:
The table is used by a DSS application.
High volume bulk loads are performed on the table.
The table is used to store archival data on which large table full-table scans (FTS) are performed.
Which row store compression would you recommend for these tables with minimal overhead on performance?
(Choose the best answer.)
A.
basic table compression for both the tables
B.
advanced row compression for both the tables
C.
basic table compression for the TRANS_HISTORY table and advanced row compression for the TRANS_DET
table
D.
basic table compression for the TRANS_DET table and advanced row compression for the TRANS_HISTORY
table
E.
warehouse compression for the TRANS_DET table and archive compression for the TRANS_HISTORY table