Internal columns into NSE

[karthik1993]

Hi Experts,

Upon running NSE advisor in SAP HANA for few days I could see that the system has recommended "$trexexternalkey$" column as a potential candidate for warm storage. However, i am not finding a way to push this into NSE as none of the queries are being supported.

Could someone help me to understand if there is any way to push this into NSE?

Br, Karthiik

[AndreyF]

Hi Kartik,

you can use point 15 from the note 2799997 - FAQ: SAP HANA Native Storage Extension (NSE)

15. How to handle NSE advisor recommendations to move columns like $trexexternalkey$ or $AWKEY_REFDOC$GJAHR$?

$trexexternalkey$ or $AWKEY_REFDOC$GJAHR$ are internal columns (SAP Note 1986747) that refer to the primary key respectively a multi-column index/concat attribute. Indexes can be moved to NSE as well.

a) identify index name:

SELECT SCHEMA_NAME, TABLE_NAME, INDEX_NAME, INDEX_TYPE, CONSTRAINT FROM INDEXES WHERE TABLE_NAME = '<table_name>';

b) change the index load granularity

ALTER INDEX "<schema>"."<index_name>" PAGE LOADABLE;example: ALTER INDEX "PLAYGROUND"."_SYS_TREE_CS_#170484_#0_#P0" PAGE LOADABLE;

Kind regards,
Andrey Farzatinov