...
View to table. How to keep the table current. Global delete from table, then insert? But you have to rebuild the index and this is labor intensive.
Two Several things in motion. Patrick with profiles maybeis still looking into setting profiles on the database somewhere. MGA's consultation replication. Patrick to create tables from views and cache the tables in memory as a way of gaining on performance. RAC.
Lock the mviews into memory - patrick. Sandra Not the same as above. Sandra will ask Patrick this.