Hi, as long as I see currently bitwise right does not use index CREATE TABLE [TestTable] ([Id] INTEGER PRIMARY KEY AUTOINCREMENT);
EXPLAIN QUERY PLAN SELECT * FROM TestTable WHERE Id >> 12 = 1000; : TABLE TestTable Sure I can replace it with the following query EXPLAIN QUERY PLAN SELECT * FROM TestTable WHERE Id BETWEEN 1000 << 12 AND (1001 << 12)-1; : TABLE TestTable USING PRIMARY KEY But the first syntax is more straightforward. Are there reasons not to implement optimization in the first case? Except for this is not most requested one :) Btw, actually, sometimes when several small fields exists and they should be indexed, one can pack them into id(rowid) to save space and the first syntax will allow querying more naturally Thanks, Max Vlasov maxerist.net _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
