]> git.ipfire.org Git - thirdparty/sqlite.git/commit
For the purpose of the query planner heuristic added by [38db9b5c83], a query
authordrh <>
Fri, 17 Jan 2025 23:49:40 +0000 (23:49 +0000)
committerdrh <>
Fri, 17 Jan 2025 23:49:40 +0000 (23:49 +0000)
commite432f2a316d281f6f4de268483fd113606ed14a7
tree39696108690e3f0cb2809e7616f79c73ff977a04
parentf462046cd14511ccfd8d819050fb2b18e5a11f61
For the purpose of the query planner heuristic added by [38db9b5c83], a query
should only count as a star query if the fact tables are connected to the
dimension table by an INNER JOIN.  If a LEFT JOIN is used, then the fact
tables are constrained to be in inner loops anyhow and so the heuristic does
not make any sense.  But it does interfere with AUTOMATIC index creation, which
causes the performance regression reported by
[forum:/forumpost/d87570a145599033|forum post d87570a1455].

FossilOrigin-Name: 0852c57ee2768224af79910e6f26e70a4962651dae0f8b45cbfc847e6707d7bb
manifest
manifest.uuid
src/where.c