On 24 Jun 2011, at 6:58pm, [email protected] wrote: > From my understanding it looks like for Integer ID columns that are PK > SQLite doesn't generate any indexes. Is this true? > > If the above is true then I want to create an index to improve the perf of > my queries that are run against it.
The indexes are generated and SQLite will use them internally whenever it finds them convenient. It's just that they are not given names, so you can find out anything about them yourself. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
