GB schrieb am 25.08.2011 18:27:
Simon Slavin schrieb am 25.08.2011 02:00:
Had you thought of creating an explicit index on the rowid column, then running
ANALYZE again ?
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I tried that, with the same result as before. It still prefers the rowid.
regards
gerd
It seems that my answer was swallowed by the recent server issues so I
thought I repost it. Sorry for any inconvenience.
regards
gerd
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users