Simon Slavin wrote: > ... if your table has lots of rows and/or you do lots of queries like > this, you should consider keeping a copy of the lower 16 bits as > another integer column.
In these case, you should consider using an expression index: sqlite> create table t(x,y); sqlite> create index tx on t(x & 0xffff); sqlite> .eqp on sqlite> select * from t where x & 0xffff = 42; --EQP-- 0,0,0,SEARCH TABLE t USING INDEX tx (<expr>=?) Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
