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.

Updated on: 12-Jun-2020

251 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements