Hey all! We have a metric column that we’re unsure is indexed correctly. Running

SELECT metric_column FROM table ORDER BY metric_column DESC LIMIT 10

results in a full table scan. So far we’ve followed the instructions for setting up a raw value forward index, but it doesn’t seem to help.

Indexing helps with filtering, your query is essentially sorting all rows of the column so it will have a full table scan

@Mayank as per my understanding for other databases, indexing improves ORDER BY queries also..is this a limitation with pinot ?

I might be missing something here, could you point me to some example databases where this happens, then I can relate back on how that is achieved on Pinot

B-tree indexes in PostgreSQL: https://www.postgresql.org/docs/11/indexes-ordering.html

I think indexes are bst /b-tree , means they contains ordered data, https://docs.mongodb.com/manual/tutorial/sort-results-with-indexes/