On Tue, 08 Apr 2014 15:22:18 +0200 Jens Miltner <[email protected]> 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 <[email protected]> _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
