On 3/31/17, aotto <aotto1...@t-online.de> wrote: > I already have a working implementation with [a] close [to] empty > *xBestIndex and *xFilter. > > 6) I expect for a primitive WHERE clause like "rep=XXX" some kind of access > optimization…
Your xBestIndex and xFilter functions must implement the desired optimization. The xBestIndex and xFilter routines work as a team. xBestIndex is passed information about the WHERE clause. xBestIndex uses that information to realize that "rep=XXX" is present, sets fields of sqlite3_index_info that cause the XXX value to be passed into xFilter, then sets idxNum or idxStr to tell xFilter what algorithm to use. xFilter will use the idxNum or idxStr values to recognize that it should jump immediately to rep=XXX. I'll see if I can work up some examples of this later today... -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users