On 25 Jun 2010, at 2:39pm, Nilesh SIMARIA wrote:
> select * from table where parent = ? and aid = ?;
>
> Our index is "create index idx on table (parent, aid)"
That should do fine. Make sure that columns which will hold integers are
defined as INTEGER, not INT or NUMBER or anything like that.
You might get a slight speed-up by asking for the columnnames explicitly rather
than using '*'.
You might get a slight speed-up by declaring this index *instead* of the other
one:
create index idx on table (parent, aid, id, name, value)
and the speed-up may or may not be worth the extra file-space used.
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
