"Nikolas Stevenson-Molnar" <[email protected]> wrote in message news:[email protected] > If I have the following table: > > CREATE TABLE stem(sid integer primary key, x double, y double, dbh > double); > > ... is there any way I can create an index for the following query? > > SELECT * FROM stem WHERE x + dbh > 20
No, not really. If you need this query often, you may want to add a column to store (x+dbh), and index that. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
