> There's your problem (and don't tell me Oracle gets this right; they
> don't do inheritance, do they?).
No, Oracle doesn't do inheritance.
> The planner isn't smart about
> indexscan-based joins for inheritance trees. This could possibly be
> improved with some work, but I haven't thought about the details.
Is there any way I could 'educate' it by using more explicit sql, or do I
have to abandon the idea of using inheritance altogether?
--
Ian Cass