]> git.ipfire.org Git - thirdparty/sqlite.git/commit
projects / thirdparty / sqlite.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 5166986) | patch
The optimizer now uses only the index and ignores the table if it can get
authordrh <drh@noemail.net>
Sun, 19 Dec 2004 00:11:35 +0000 (00:11 +0000)
committerdrh <drh@noemail.net>
Sun, 19 Dec 2004 00:11:35 +0000 (00:11 +0000)
commit9012bcbc0a72d650fc2e391bcd450a4c7d294de1
tree5c358edbd4658edb0b5526cf5943b3d2e9b3bf2btree | snapshot
parent51669863a83aa0fb9aacdb9744f80ab234d72530commit | diff
The optimizer now uses only the index and ignores the table if it can get
away with doing so, thus saving a single BTree search per row of result.
This could potentially double the speed of certain queries.  The
code passes all regression tests but new tests to exercise the new
functionality are yet to be added. (CVS 2170)

FossilOrigin-Name: e5aa489453bf31126da6473ef93c89ec27935cde
manifest diff | blob | blame | history
manifest.uuid diff | blob | blame | history
src/sqliteInt.h diff | blob | blame | history
src/vdbe.c diff | blob | blame | history
src/where.c diff | blob | blame | history
test/collate4.test diff | blob | blame | history
test/where.test diff | blob | blame | history
Mirror of https://github.com/sqlite/sqlite.git