Some said materialized views are not a good way to go in an OLTP database. I responded on a different thread and was kicked back by the LazyDBA email Nazi; hope this one gets through...

Depends on the frequency at the which the materialized view is refreshed, and
the configuration you've applied to your database. Configure properly, watch
your scheduling, and the MV can work very well.

Nick

-------------- Original message --------------
From: "Jeff Ferrel " <oracledba-ezmlmshield-x10264957.[Email address protected]

>
> I have a developer that has run into this as well. I'd like to see more
> discussion on this, or if someone has access to any articles on this
> topic, please send them my way!
>
> Thanks to all,
>
> Jeffrey C. Ferrel
> DMS III
> State of Nevada
> 775.687.9327
> [Email address protected]
>
>
> -----Original Message-----
> From: Chamberlain John
> [mailto:oracledba-ezmlmshield-x87208536.[Email address protected]
> Sent: Wednesday, January 03, 2007 1:11 AM
> To: LazyDBA Discussion
> Subject: RE: Why Views are slow
>
>
> Views are not slow, but the query that constitutes the view may be. Try
> running the select statement that makes the view and then select from
> the
> view itself. Don't forget to apply the usual expected where clauses. The
> results should be pretty similar. Run some explain plans to check this.
>
> John.
>
> -----Original Message-----
> From: Sadiq Noorulla
> [mailto:oracledba-ezmlmshield-x33925902.[Email address protected]
> Sent: 03 January 2007 03:21
> To: LazyDBA Discussion
> Subject: Why Views are slow
>
> Hi Oracle Experts,
>
> I found quires using base table is Fast
> same after creation of view is Becoming Slow
>
> Any Reason
>
> Thanks in Advance
> DISCLAIMER:
>
> This message contains privileged and confidential information and is
> intended only for the individual named. If you are not the intended
> recipient you should not disseminate,distribute,store,print, copy or
> deliver
> this message. Please notify the sender immediately by e-mail if you have
> received this e-mail by mistake and delete this e-mail from your system.
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
> -----------------------------------------
> Information in this email including any attachments may be
> privileged, confidential and is intended exclusively for the
> addressee. The views expressed may not be official policy, but the
> personal views of the originator. If you have received it in error,
> please notify the sender by return e-mail and delete it from your
> system. You should not reproduce, distribute, store, retransmit,
> use or disclose its contents to anyone.
>
> Please note we reserve the right to monitor all e-mail
> communication through our internal and external networks.
>
> SKY and the SKY marks are trade marks of British Sky Broadcasting
> Group plc and are used under licence. British Sky Broadcasting
> Limited (Registration No. 2906991), Sky Interactive Limited
> (Registration No. 3554332), Sky-In-Home Service Limited
> (Registration No. 2067075) and Sky Subscribers Services Limited
> (Registration No. 2340150) are direct or indirect subsidiaries of
> British Sky Broadcasting Group plc (Registration No. 2247735). All
> of the companies mentioned in this paragraph are incorporated in
> England and Wales and share the same registered office at Grant
> Way, Isleworth, Middlesex TW7 5QD.
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>

Oracle LazyDBA home page