On Jun 24, 2011, at 1:58 PM, logan...@gmail.com wrote: > Sorry, but seems like I'm missing something here. > > From my understanding it looks like for Integer ID columns that are PK > SQLite doesn't generate any indexes. Is this true? >
No, what you think is not true. SQLite does generate an index for INTEGER PRIMARY KEY columns. > If the above is true then I want to create an index to improve the perf of > my queries that are run against it. > > Thanks, > Hitesh > > On Fri, Jun 24, 2011 at 5:31 AM, Igor Tandetnik <itandet...@mvps.org> wrote: > >> logan...@gmail.com wrote: >>> Yes, that's exactly what it is. Here is the definition of one of the >> table: >>> >>> CREATE TABLE [Attributes] ( >>> [Id] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, >>> [Name] VARCHAR(50) NOT NULL >>> ) >>> >>> Will creating explicit index on Id fix this issue? >> >> What issue? Why is having an explicit index, separate from that built into >> the table itself, important to you? What exactly do you feel is wrong with >> the way things are now? >> -- >> Igor Tandetnik >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users