Re: View based upon function won't use index on joins

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