[sqlite] Warning automatic index on

[Werner Kleiner]

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