Which compression method is recommended for Direct-Path Insert operations?
Which compression method is recommended for Direct-Path Insert operations?
For Direct-Path Insert operations, the recommended compression method is ROW STORE COMPRESS BASIC. This method is suitable for bulk data loading, which is typically performed using direct-path insert operations. It provides a good balance between compression efficiency and performance.
why A? it is not good for OLTP. B is good for both DWH and OLTP
Correct answer is A.
You sure it is A ? I will go for B instead
https://blogs.oracle.com/dbstorage/post/when-to-use-and-not-use-the-different-types-of-oracle-database-19c-data-compression
The correct answer is A
The correct answer is A ROW STORE BASIC only because the question says Direct-Path and not including DML, if DML then the correct will be C Column store advanced
correct answer is A