On Oct 8, 2011, at 4:42 PM, Mohit Sindhwani wrote: > We have many table that have zid (unique) and all will usually have an index > on zid and (zid,...) for other queries.
If 'zid' is your primary key (INTEGER PRIMARY KEY), then there is no need to index it again, as it's an alias for the table internal rowid. Check 'ROWIDs and the INTEGER PRIMARY KEY' in the fine manual: http://www.sqlite.org/lang_createtable.html _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
