Hi everyone,
I'm trying to improve SELECT queries on a db I created.
Here's the part I think is relevant:
create table featureSet (fsetid integer primary key, man_fsetid text,
chrom text);
create table pmfeature (fid integer primary key, fsetid not null
references "featureSet" ("fsetid"), x integer, y integer);
create index man_fsetid_idx on featureSet ("man_fsetid");
create index fset_idx_chrom on featureSet ("chrom");
create index fset_idx_fsetid on featureSet ("fsetid");
create index pmf_idx_fsetid on pmfeature ("fsetid");
And then I need to run many queries like:
SELECT fid, man_fsetid, pmfeature.allele, pmfeature.strand FROM
featureSet, pmfeature WHERE man_fsetid IN (<LONG LIST HERE>) AND
pmfeature.fsetid = featureSet.fsetid ORDER BY fid
That list usually contains 10K or more "man_fsetid" elements.
The featureSet table has about 945K records.
The pmfeature table has about 7M records.
I'd very much appreciate if anybody more experienced in this field
could give me some hints on how to improve this.
Thank you very much,
Benilton
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
