Not all data is in memory on an in memory table
SummaryHow to get 100% of content into an in memory table
I have a table WC_LEAVE_LIAB_F defined as In memory
I believe it was 100% in memory as graphs were generated quickly
I applied the BTREE index on SNAPSHOT_DT and the table queries now return quickly, however the performance of the chart has dropped
Looking at the inmemory stats on V$IM_SEGMENTS there is a large amount of data reported as BYTES_NOT_POPULATED so guessing some data has been knocked out of memory since the index creation.
How can I get this data back in memory?