]> git.ipfire.org Git - thirdparty/sqlite.git/commit
Demonstration code on a possible technique for optimizing the use of IN
authordrh <drh@noemail.net>
Wed, 30 May 2018 00:54:23 +0000 (00:54 +0000)
committerdrh <drh@noemail.net>
Wed, 30 May 2018 00:54:23 +0000 (00:54 +0000)
commita0368d9396ea3c8cb80f902cacb7594039909bb2
tree0af5c0f2f2ea85760987c67c7123638b178a167a
parentea93e2804d46ae1279c7112505eab55579b40dc9
Demonstration code on a possible technique for optimizing the use of IN
operator on columns to the right of multicolumn indexes.  If the OP_Noop
generated where were really a new opcode that checked to see if there existed
any entries in the index with a matching prefix, it might prevent unnecessary
iterations of the IN operator.

FossilOrigin-Name: 92f0fe155d5546fc7f4a443d0630613dabe149061966308e5420fad652278f16
manifest
manifest.uuid
src/where.c
src/whereInt.h
src/wherecode.c