Does it have it in it?
Yes. it does.
Materialized Views are supported in the following databases: Oracle 11g, Oracle 10g and 9i, DB 2 v. 9.5 (LUW), DB 2 v. 9 (LUW), DB2 UDB v. 8 (LUW).
See the Materialized View icon on the toolbar or in the Objects menu.
For more details, have a look at the Help file, on Index tab please type “materialized” and see the topic materialized views.
If you have more questions, please write me back. Thanks.