Apache Pinot

Hello team! I had a quick question if query plan shows `FILTER_SORTED_INDEX` would it be the same as using `FILTER_INVERTED_INDEX` like sorted inverted index?

No, one is using the sorted column, the other is using the inv index.

<@U082F22LM4Y> Are you asking about which index would perform best for your use case?

Thank you for the follow up! Based on the doc (<https://docs.pinot.apache.org/basics/indexing/inverted-index?q=segment+configuration&amp;global=true#sorted-inverted-index:~:text=Consequently%2C%20when%20these%20conditions%20are%20met%2C%20an%20inverted%20index%20is%20effectively%20created%20without%20additional%20configuration%2C%20even%20if%20the%20configuration%20suggests%20otherwise|https://docs.pinot.apache.org/basics/indexing/inverted-index?q=segment+configuration&amp;global=true#sorted-inverted-index:~:[…]n%20suggests%20otherwise>) seems like _sorted inverted index_ is enabled without any configuration if the column is sorted and it is a dictionary index. I have enabled the column to be sorted and dictionary, but I'm seeing that it is using `FILTER_SORTED_INDEX` instead of `FILTER_INVERTED_INDEX`  and wanted to see if this would be already using inverted index behind the scene.

Yes sorted column storage duals as forward and inverted index 

Sorted is typically better because of locality 

If column is already sorted then pinot won't create inverted index and always use sorted index