Kristof Van Landschoot <kris...@coin-c.com> wrote: > Why doesn't sqlite implement a hash tag on strings itself when there is an > index?
Because a hash would only help with conditions of the form "textField = ?", while the kind of b-tree index that SQLite utilizes also works for "textField > ?" and "order by textField". -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users