Quote Originally Posted by slimdave
Yes, but it's not got very far yet ...

So what were the reasons for rejecting the MV then?
Dave its reservation availability the problems with synching outweigh the gains. In fact we will leave out those aspects and just pre-join the other 20 tables and batch changes, then pre-join at night. There is nothing left for the mview to do we dont need query rewrite as we are always going against the rollup and we dont need auto synch.