Srinivas Iyyer <srini_iyyer_bio@yahoo.com> writes:
> Sorry Tom, for the confusion.
> seq_id is not equal to go_id
> seq_id = NM_000033
> go_is = GO:049934
So how do you know which ones are related? If there's a table showing
the relationship, joining against that is the way to go. You might also
want to rethink your choice of data keys --- if there isn't a simple way
to join related rows in different tables, you've chosen a poor data
representation.
A small tip is that integer or bigint keys are likely to perform better
than strings ... but this is definitely a second-order effect, and I
don't think you've yet got the first-order representational decisions
correct.
regards, tom lane