Well indexing (or lack thereof) could be the real problem but you could
try "chaining" the tables
select * from sale s, taxes t, property p, buyer b
where s.id = t.id and t.id = p.id and p.id = b.id
and see if that (or other combination) changes the query plan appreciably.
(I would have to wo
Hey Folks,
I have a query that seems like it will never end. I'm hoping you can help
me rewrite it.
I have 4 tables that contain information about house sales within the state
(sale, taxes, property, buyer). Each table has an 'id' field that links
each record. I am just trying to flatten thes
