On Tue, 08 Apr 2014 15:22:18 +0200 Jens Miltner <j...@mac.com> wrote:
> CREATE INDEX a_idx1 ON a(b_id); > CREATE INDEX a_idx2 ON a(identifier, b_id); > > both of which could be used according to the JOIN statement and/or > the CASE statement (if this part would use an index at all). > > > I understand it's hard to tell where the problem is without knowing > the complete query details, but maybe some hint on what would prevent > the use of a regular index might help pointing me in the right > direction... Did you run ANALYZE? Is b_id table a primary key? If it is then delete it because Sqlite adds primary key on indexs by default. Run analyze/reindex after change. > > Thanks, > -jens > > --- --- Eduardo Morras <emorr...@yahoo.es> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
