> > 0 0 1 SCAN TABLE d_table_b AS da (~100000 rows) > > > > Is this the index you referenced in you reply to Simon? > Maybe you are using wrong index/column?
I'll recheck, I am also reading up on indexes as they relate to optimizing queries. Could be I made a mistake. > I had the same problem (kind of) and got the answer here to create a > different index... > > Thank you. > > Can you post you schema? Sure, it's not mine technically so I have to sanitize portions. Thanks, jlc _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users