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

Reply via email to