PM Nik Jain wrote: > A SCAN is being performed on a fts5 table. I am not sure but I > think that means no index. > > sqlite> explain query plan select * from productsfts p where p.attributes > match '50' limit 6; > `--SCAN TABLE productsfts AS p VIRTUAL TABLE INDEX 1:
Everything except "INDEX 0" means that it is not a plain table scan, but that the virtual table module does its own filtering. Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
