Creating Index in Column based tables in SAP HANA



Note that an index not necessary to be NOT NULL. You can create an Index in SAP HANA database by using below query:

CREATE INDEX IDX_MY_INDEX ON TABLE1 (MY_COLUMN);

To know more about SAP HANA database, Modeling, and Administration features, you can refer our SAP HANA Text and Video tutorials:

https://www.tutorialspoint.com/sap_hana/

https://www.tutorialspoint.com/sap_hana_online_training/index.asp

Samual Sam
Samual Sam

Learning faster. Every day.


Advertisements