query optimization

Hi everybody,

I've got two queries that needs optimizing. Actually, there are others,
but these are pretty representative.

You can see the queries and the corresponding plans at

http://bulldog.duhs.duke.edu/~faheem/snpdb/opt.pdf

or

http://bulldog.duhs.duke.edu/~faheem/snpdb/opt.tex

if you prefer text (latex file, effectively text in this case)

The background to this is at
http://bulldog.duhs.duke.edu/~faheem/snpdb/diag.pdf

If more details are required, let me know and I can add them. I'd
appreciate suggestions about how to make these queries go faster.

Please CC this email address on any replies.

                                    Regards, Faheem.