You want to create a table, DAILY_ORDERS, for an OLTP application, where data should be compressed during both direct path INSERT and conventional DML. The table will also be used for queries.
Which compression option should be used? (Choose the best answer)
A.
ROW STORE COMPRESS
B.
COLUMN STORE COMPRESS FOR QUERY
C.
COLUMN STORE COMPRESS FOR ARCHIVE LOW
D.
ROW STORE COMPRESS ADVANCED
Explanation:
D