if we have any column with large string/text values and we want it to be indexed then there is no choice but to go for a hash index. Please correct me if I'm wrong.
There are other strategies / solutions, but we would need to learn more about your use case.
Cheers,
Greg
