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?
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
