Hello,
In an error log there is a message like:
SQlite warning (284) automatic index on is_mytable(internalvalue)
What does this mean?
Can sqlite not use the index correct?
How can we check or optimize the index?
What do I have to do to cancel the message?
Here is the Table DDL:
-- Table: is_mytable
CREATE TABLE "is_mytable" (
"mytableid" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL ,
"compcid" INT NULL DEFAULT 0 ,
"installid" INT NOT NULL DEFAULT 276 ,
"internalvalue" VARCHAR(250) NOT NULL COLLATE NOCASE,
"namekey" VARCHAR(250) NOT NULL DEFAULT 'Document' COLLATE NOCASE,
"textid" INT NOT NULL ,"defaultvalue" INT NOT NULL DEFAULT 0 );
-- Index: InternalName
CREATE INDEX 'InternalName' ON 'is_mytable' (`internalvalue` DESC);
-- Index: OpenUI
CREATE INDEX 'OpenUI' ON 'is_mytable' (`namekey` DESC);
-- Index: idx_mytable_compcid
CREATE INDEX 'idx_mytable_compcid' ON 'is_mytable' (`compcid` DESC);
-- Index: idx_mytable_internalvalue
CREATE INDEX idx_mytable_internalvalue ON is_mytable (internalvalue);
regards
Werner
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
