Hello PI > change your query a bit when you use bitwise operations, in your case when you PI > have 'AND col_c&32' you may add 'AND col_c>=32'. now index will be used
PI col_c = 64 does pass second condition and doesn't pass first one. ;-) PI Bitwise operators cannot be changed so easily to inequalities. Wasn't the idea that the index would get used for the equality test, and the more expensive bitwise comparison would then be run on a smaller number of rows? I don't know if this is possible. But that is how I imagined the suggestion. Swithun. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
