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

Published on 20-Dec-2017 09:27:15

Previous Page Print Page

Advertisements