Re: materialized view

No. Materialized views have two main advantages: - They can be updated automatically - The optimizer can take advantage of them to give quicker answers You don't need the second, so you could think about implementing the first one with triggers. Regards. On Sat, Mar 27, 2010 at 5:21 PM, Floyd Wellershaus <floyd@fwellers.com>wrote: > Is there the equivalent of Oracle's materialized view available in Informix > 11.5 ? > We are migrating data that will require an initial bulk load from Informix > to Oracle, and then delta loads. > We were going to use HP Loader to unload files and then have an ETL process > ( ODI ) to clean the data, massage it and bring it into Oracle. > > However there are numerous issues, things like the backslashes in unload > files on varchar character types, date field differences and such that make > our developers want to go directly against the informix tables for the loads > ( table to table - informix to Oracle ) instead of using the intermediate > step of unload files. > > The performance could suck on that. Materialzied views would be a possible > solution. So I'm checking. > > Thanks, > floyd > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...