Which three aspects should you consider before you choo…

You have been asked to assess if using column store compression (previously known as hybrid columnar
compression or HCC) would help improve the performance of queries on some large tables.
Which three aspects should you consider before you choose this compression method? (Choose three.)

You have been asked to assess if using column store compression (previously known as hybrid columnar
compression or HCC) would help improve the performance of queries on some large tables.
Which three aspects should you consider before you choose this compression method? (Choose three.)

A.
Check whether direct path load operations are used to insert rows in the table.

B.
Check whether the table is frequently queried using full table scans as column store compression only
minimizes I/O during full table scans.

C.
Check whether the table is frequently updated because it will have overhead for insert and update
operations.

D.
Check whether the table has LOB columns as it will minimize I/O for the queries.

E.
Check whether the table blocks are sparsely populated as this will defragment the blocks.



Leave a Reply 0

Your email address will not be published. Required fields are marked *