Re: [sqlite] Do I still need an index if I have a composite Primary Key(or UNIQUE)

Florian Kusche wrote: > in my application, an Icon is made up of one or more layers of images: > > CREATE TABLE IconLayer > ( > IconID INTEGER NOT NULL, > Order INTEGER NOT NULL, > ImageID INTEGER NOT NULL REFERENCES Image( _id ), > > PRIMARY KEY ( IconID, Order ) > ); > > During runtime

[sqlite] Do I still need an index if I have a composite Primary Key (or UNIQUE)

Hi, in my application, an Icon is made up of one or more layers of images: CREATE TABLE IconLayer ( IconID INTEGER NOT NULL, Order INTEGER NOT NULL, ImageID INTEGER NOT NULL REFERENCES Image( _id ), PRIMARY KEY ( IconID, Order ) ); During runtime, I want to get the layers of my Icons