TopK Score with Tiebreaker (Single Table, BM25)

  • Description: BM25 score ordered DESC with a primary key tiebreaker and LIMIT 10. This tests that the Block-Max WAND optimization is able to trigger when a score is used as a prefix in the ORDER BY clause along with a tiebreaker.

Query Info (statistics from 1M dataset; larger datasets may have different values):

  • ‘javascript’ selectivity on stackoverflow_posts.body: ~4%