Skip to Content
avatar image
Former Member

What's the use of $_SYS_SHADOW_<column_name>$?

Hi all,

I am using datatype shorttext in a SAP HANA columnar table. Getting the corresponding details from M_CS_ALL_COLUMNS shows, that for the column with data type 'shorttext' an additional, internal column $_SYS_SHADOW_<column_name>$ exists (which by the way occupies lots of memory).

What's the purpose of this 'shadow column'? Is it always generated autmatically for shortext data type? Are there other data types which also lead to  'shadow columns'?''

Thanks.

Cheers, Stefan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jan 15, 2015 at 05:23 PM

    Folks,

    just recognized that datatype shorttext is enabled for full-text search automatically.

    This is the reason why the $_SYS_SHADOW....$ column is created directly.

    Best,

    Stefan

    Add comment
    10|10000 characters needed characters exceeded