Categories

Can we use INMEMORY and Advanced Row Compression together

User_BGF4N
User_BGF4N Posts: 1 Green Ribbon
edited February 2022 in General

We are currently using Oracle database 19c. There is a table around 150GB which is used in OLTP and Datawarehouse environments separately. Table is growing approximately 100GB/year.

Customer cannot purge data in table as they need all historical data from table. Also partitioning is not going to help in their scenario.

Can we use Advanced Row Compression feature along with INMEMORY feature for this table for performance benefit in Select queries or DML operations?