Kristof Van Landschoot <[email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
