Skip to main content

Encoding type vs encodings

  • August 22, 2017
  • 0 replies
  • 2 views

mmuthukr

what is the difference between encoding type specified in the projection_column table and encodings specified in column_storage table.

below is the sample data from
v_catalog.PROJECTION_COLUMNS ,

v_monitor.column_storage

data_type encoding_type encodings compressions
varchar(12) AUTO String lzo
varchar(9) AUTO String lzo
varchar(9) AUTO String lzo
date AUTO Uncompressed int delta
date AUTO Uncompressed int delta
varchar(7) AUTO String lzo