Sorry yeah I had to edit the query away from my real domain, NDA and all that.
Yeah I've been using explain and learning what PostgreSQL means with it (I'm used to MySQL), and I know much better now what their version of explain says since I asked this question so I'll have to go back and see what it says.
A cat is an animal, a house has one or more animals (and therefore one or more cats), an animal (and cat) has one or more houses. house_animal stores the relationship between them.
|