Re: [sqlite] Join on same table and performance.

[Doug Currie]

Friday, March 24, 2006, 2:33:36 PM, Tobias Rundström wrote:

> [...]
> The schema is this:

> create table Media (id integer, key, value, source integer);
> and the indexes:
> create unique index key_idx on Media (id,key,source);
> create index prop_idx on Media (key,value);
> create index source_idx on Media (key,source);
> create index key_source_val_idx on Media (key,source,value);

I wonder what effect

create table Media (id INTEGER PRIMARY KEY, key, value, source integer);

would have on your query time. This would use the already built-in
BTree index.

e

-- 
Doug Currie
Londonderry, NH