L B <[EMAIL PROTECTED]> wrote: > The explanation you made is only valid for sqlite or > for SQL in general?
For SQL in general. > Moreover, the query: > > select * from mytable where X=?; > > would still benefit the index on (X, Y, Z)? Yes. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users