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