cancel
Showing results for 
Search instead for 
Did you mean: 

Unused tables which are loaded into memory

Former Member
0 Kudos

Hi,

How do we check the no. of column store tables which are loaded into memory and not used frequently.

Thanks

Mahesh

Accepted Solutions (1)

Accepted Solutions (1)

Amit_Tewatia
Active Participant
0 Kudos

standard query is provided for this: M_CS_COLUMN

M_CS_COLUMN provides runtime information of column tables.



Column LAST_ACCESS_TIME and LAST_LOAD_TIME provide the frequency of data accessed, which is in memory.


Regards,

Amit T

Answers (1)

Answers (1)

davidebruno
Participant
0 Kudos

you can query in the view

M_CS_COLUMNS

there is the field LAST_ACCESS_TIME