Of course you can only use PARALLEL if you have that option enabled. Materialized view are good because they can speed up complex queries, Oracle will change queries to use Materialized views. So you don't need to change your Sql to point to the materialized view. According to a white paper I read from Oracle you should not write queies directly against materialized views. hopefully this helps.
:cool:

11-07-2002, 08:52 AM

Chandra

I what to know how to create on the OBJECT TYPE NOT ON TABLE.

Thanks.

11-07-2002, 09:53 AM

gandolf989

Sorry I misunderstood. Stephen Feuerstein has a good article on this subject.