Glean 拾遗
日刊Daily /2026-05-25 / SQLite 改写 query planner,复杂连接快 4 倍 SQLite rewrites query planner: 4× on complex joins

SQLite 改写 query planner,复杂连接快 4 倍 SQLite rewrites query planner: 4× on complex joins

原文Source sqlite.org 推荐By anon 收录Glean'd 2026-05-25 11:33 阅读Read 6 min
原文 sqlite.org ↗ sqlite.org ↗
§ 摘要 · Summary

NGQP+ reorders joins by selectivity, biggest wins on 7+ table queries; ATTACH cost model fixed. Notion-style nested queries see the largest gains.

NGQP+ 按选择度重排连接顺序,对 7 表以上查询特别明显,ATTACH 数据库成本模型也修了。Notion 风格嵌套查询提升最显著。

打开原文 ↗ Open source ↗