Skip to Content
0
Sep 18, 2019 at 12:55 PM

HANA indexing options

181 Views

I have a couple of questions concerning indexing in HANA.

  1. for row-store storage
  • With row-store storage, most likely OLTP operations, we use both primary and secondary indexes(aka clustered and non clustered)?
  • do row store indexes use b-tree structures?

2. Column-store-storage

  • are there special indexes especially for column store storage, which differ from row-store indexes in their structure of keeping data in storage
  • do we again have primary and secondary column store indexes here? again two types => 4 types of indexes
  • row store primary
  • row store secondary
  • col store primary
  • col store secondary ??

3. do secondary indexes contain included columns?

Please provide detailed answers,

Thanks for your time!