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

e

Updated on: 11-Dec-2019

896 Views

Kickstart Your Career

Get certified by completing the course

Get Started