#search

Engineering · 17 · 8 min

Hybrid search done right: lexical, vector, and filter in one plan

A walk through the RedDB query planner fusing BM25, vector similarity, and a structured filter into a single execution plan — with EXPLAIN output, the cost model behind it, and what happens on the edge cases that trip up naive two-stage rerankers.