I have a couple of questions concerning indexing in HANA.
- 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!