Re: [GENERAL] hopefully a brain teaser, can't quite figure out query

2008-06-07 Thread Adam Rich
> -Original Message- > The small table is a listing of county fips codes, their name, and the > geometry for the county. Each fips is only listed once. The big table > is multiple emissions for each county, the parameter for the emission, > and the source code for the emission (scc). Each

[GENERAL] hopefully a brain teaser, can't quite figure out query

2008-06-07 Thread edfialk
Hi guys, maybe this is just a teaser for me, but any help would be awesome. My best crack at the solution is not returning yet after a good ten minutes. I'll post the explain analyze if it ever comes back. I have no indexing, which is probably embarrassing, I'm just not quite sure what to index