Re: 2 million row database from hell! help a newbie in over his head.

I was referring to Query Rewrite for Oracle Materialized Views. BTW it's data warehousing feature. Data warehousing, however is part of standard oracle.

http://www.oradoc.com/ora817/server.817/a76994/mv.htm#40592

See also

http://groups.google.com/groups?q=query+rewrite+group:comp.databases.oracle.server+author:Kyte&hl=en&safe=off&rnum=5&selm=9jqat502gng%40drn.newsguy.com

In article <VxNh7.318$Iw2.22285_at_petpeeve.ziplink.net>, David Cressey says...
>
>Carl,
>
>I'm also confused by Mikito's writing.
>
>As far as materialized views go, you can use that term to describe a
>product specific feature, or you can use the same term to refer to a
>concept that is available in all relational DBMSes I'm aware of.
>
>Oracle's snapshots play the role, conceptually, of a materialized view.
>
>
>
>--
>Regards,
> David Cressey
> www.dcressey.com
>
>
Received on Sun Aug 26 2001 - 04:35:07 CEST