On Tue, Sep 13, 2011 at 6:23 AM, François <francois.goldgewi...@gmail.com>wrote:
> Hello, > > Let us consider a table "ITEM" with a BOOLEAN field "FLAG". This table > may contain up to 100 000 entries and those entries can be selected > using "WHERE ITEM.FLAG = ?" conditions. > > Is then a good or a bad practice to add an index on this field if we > want to improve SELECT time execution ? > Bad practice. It will likely make things worse, not better. > > Please note that it concerns an iPhone app. > > Thank you ! > > Best Regards, > > François > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users