Default table type in SAP HANA database

SAP HANASAPSAP Basis

By default it creates a Row store table. The horizontal lines in front of table name represents row based storage table in database. HANA database also supports column store tables but you need to add a keyword “Column” in create table query.

Below snapshot confirms that by default a row based table is created.

raja
Published on 21-Feb-2018 23:14:50
Advertisements