2009/11/20 Jonathan Foy <thefoy@gmail.com>:
> Shy of just throwing a trigger in the
> table to actually populate a second table with the same data solely for
> reporting purposes,
That's what I would do in your situation, FWIW. Query optimization is
a hard problem even under the best of circumstances; getting the
planner to DTRT with a crazy schema is - well, really hard.
...Robert