I have a schema with the following definition:
CREATE TABLE "XPOST"("GNAME" TEXT, "AN" INT, "TIME" INT, PRIMARY KEY
("GNAME", "AN", "TIME")) WITHOUT ROWID;
However, the order by "AN" and the order by "TIME" will be the same order.
(I also have a table "ART" where "AN" is the rowid, and again the order by
"TIME" will be the same order.)
How can you make SQLite to make that assumption in order to optimize the query?
(It should be done presumably without adding another index, since the data is
already in the correct order.)
(This is my "sqlnetnews" NNTP server software, which is public domain open
source. I don't know if maybe you might want to use NNTP for your mailing
lists?)
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
