[robintiman11]

Yeah I’d say sorting by relevance is similar but MEANS is strictly a boolean operator only allowed in WHERE clauses at the moment.

The way it works is: 1. Prune rows based on semantic index 2. Run surviving rows through the LLM which answer yes or no to the given predicate. 3. Collect final result.

Order by relevance is on the roadmap but I haven’t given it much thought.

The use case I’ve been working with is querying meeting transcripts. May I ask what your use cases are and how you’d like order by relevance to work?

[malandin]

A-ha! So you have re-ranking discreetly baked into the pipeline. I'd argue that this could be better for a user to decide but it depends on the use-case really. Speaking of 'order by relevance', the cases that I had in mind could be connected to the re-ranking use case. For example, what if I was looking for a photo of a chihuahua and then wanted to take the best 20 and run them through a re-ranker to come up with the best 5 (or best 1 even).