And to top it off use Function results cache in 11g, BINGO !! On Tue, Apr 29, 2008 at 2:33 PM, Stephane Faroult <sfaroult@xxxxxxxxxxxx> wrote: > I fully second Dan on this. It's very easy to get a lot of "perfect" small > queries. Just write lots of functions: > > Then use the functions everywhere ... > >