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 ? 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