On Nov 20, 2008, at 7:17 AM, Christophe Leske wrote: > >> The INTEGER PRIMARY KEY is always included in every index as an >> implied extra column on the end. If you explicitly add the INTEGER >> PRIMARY KEY as a column in the index, then you have it in the index >> twice, which serves no purpose but does confuse the optimizer. Don't >> do that. >> > Any chance to spare the ID field and get an index on the rowid for a > given table? >
I do not understand the question. Please rephrase. Use more words. D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
