You want to use table compression suitable for OLTP that will:1. Compress rows for all DML statements on that table2. Mi
Posted: Sun Jun 11, 2023 3:55 pm
You want to use table compression suitable for OLTP that will:1. Compress rows for all DML statements on that table2. Minimize the overheads associated with compressionWhich compression option is best suited for this?
A. COLUMN STORE COMPRESS FOR QUERY LOW
B. ROW STORE COMPRESS BASIC
C. COLUMN STORE COMPRESS FOR ARCHIVE LOW
D. COLUMN STORE COMPRESS FOR ARCHIVE HIGH E. ROW STORE COMPRESS ADVANCED
A. COLUMN STORE COMPRESS FOR QUERY LOW
B. ROW STORE COMPRESS BASIC
C. COLUMN STORE COMPRESS FOR ARCHIVE LOW
D. COLUMN STORE COMPRESS FOR ARCHIVE HIGH E. ROW STORE COMPRESS ADVANCED