Serge,
Kewl. But does a refresh mean a rebuild? Is it that way for Oracle? A
rebuild would be the same as we are doing now, which is to create table
like view and select * from the view and insert into the created table.
What were trying to do is avoid the rebuild of the entire contents, since
it will be on the order of 100 million rows.
Thanks,
M
Serge Rielau <sr*****@ca.eye-bee-em.com> wrote in news:L9VUc.422132
$r**********@news01.bloor.is.net.cable.rogers.com:
It's called a Materialized Query Table (MQT) in DB2.
Check out the CREATE TABLE statement and SET INTEGRITY.
You can refresh yourself, or you can have DB2 refresh for you
immediately or at a later time.
Cheers
Serge