Getting an error on creating an Index in SAP HANA

I think if you would have gone through the documentation or gone through the message “column already indexed” carefully, you would have figured out that the index already exists.

If the data type of the column is TEXT then HANA by default creates an index on it. What you can do for better performance is change the data type of the column to BLOB.

BLOB − stores large amount of Binary data.

SAP ABAP Expert

Published on 06-Dec-2017 21:38:34

• Related Questions & Answers
• Creating an Attribute view in SAP HANA
• Getting an error- license key couldn’t be installed in SAP HANA
• Getting memory error while doing UNION in SAP HANA
• Getting error while using schema in SAP HANA Modeling
• Getting an error invalid Object Name in SAP Business One
• Getting error message: Scalar type not allowed in SAP HANA
• Creating Index in Column based tables in SAP HANA
• Creating an index on a nested MongoDB field?
• Getting error not assigned on running SAP ABAP program
• Creating a copy of an existing Attribute view in SAP HANA
• Getting an error while previewing swf file from XML data in SAP Dashboard Designer
• Getting error while extracting data from SAP
• Getting more rows returned than expected on doing SUM in SAP HANA
• Creating a new table in SAP HANA
• Creating a Restricted user in SAP HANA