I think it's a simple question, so I'm asking it h...
# general
u
I think it's a simple question, so I'm asking it here. The column 'TEST_COLUMN' has high cardinality. (This is the only value.) Is applying inverted index and sorted column together beneficial to query performance? If the question is not detailed and abstract, please let me know. Thank you always.
m
Sorted column inherently gets an index so you don't need explicit inverted index on sorted columns.
Typically, you want to set sorted index on a column where most queries have an equality predicate.
u
Yes, thank you so much for your reply with detailed explanation.
👍 1