"Nikolas Stevenson-Molnar" <steve...@evergreen.edu> wrote in message news:f45a26bc-1ee8-4a72-a90a-77f40eef6...@evergreen.edu > 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users