Worked on the lancedb/lance repository to deliver a performance-focused enhancement for B-Tree index searches, specifically optimizing IN-list queries. The approach involved compiling the IsIn predicate once per search and reusing a prebuilt expression across all relevant pages, which reduced per-page computation and improved scalability for large datasets. Using Rust and leveraging DataFusion, this change enabled a roughly fourfold reduction in query latency on an 83-million-row table, with membership checks now operating in constant time per row. The update maintained existing API behavior, passed comprehensive test suites, and improved analytics workloads without introducing regressions or altering user-facing interfaces.