]> git.ipfire.org Git - thirdparty/sqlite.git/commit
projects / thirdparty / sqlite.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(merge: b1ed717 5713115)
When doing a DISTINCT query using an index, try to use the index to skip ahead
authordrh <drh@noemail.net>
Fri, 14 Apr 2017 17:30:43 +0000 (17:30 +0000)
committerdrh <drh@noemail.net>
Fri, 14 Apr 2017 17:30:43 +0000 (17:30 +0000)
commit1a17b44231b0116fcd065043ac722443bc2f4f7f
treee95acc0290aaa06d0dc13fe5b0987e2c51505e61tree | snapshot
parentb1ed717f18d1e08c6c2ab52c020a4b0748302b1acommit | diff
parent571311502dba4e542aa23b043308c68c94128655commit | diff
When doing a DISTINCT query using an index, try to use the index to skip ahead
to the next distinct element, rather than doing a full scan of the index.
(This is the "skip-ahead-distinct" optimization.)

FossilOrigin-Name: f489b5bb6b35665befdd411c2c55df5258e83cba265d8c4427ba22529cf882a4
manifest diff1 | diff2 | blob | history
manifest.uuid diff1 | diff2 | blob | history
Mirror of https://github.com/sqlite/sqlite.git