RE: Anybody against using views?

View positives:

They simplify what the developer and user see, thus making SQL logically simple

You can put hints on a view, thus forcing the optimizer to use the view as you know best. This can sometimes be the only way to optimize a third party application that puts all its SQL in a black box.

View negatives

They're just stored SQL, so the impression that they are some kind of table can lull users and developers into thinking that it's perfectly alright to nest the heck out of them in statements...which is bad in almost all cases

They hide the reality of underlying physical objects. Sometimes when you carve away all the views you find that you should redesign the tables themselves to allow for cleaner SQL.

And finally one item that is neither positive nor negative. A materialized view (aka snapshot) can get you massive performance gains if used well, but that's more like a table than it is a view.

> -----Original Message-----
> Sent: Thursday, February 21, 2002 9:18 AM
> To: Multiple recipients of list ORACLE-L
>
>
> We have several applications that use views extensively. On the other hand
> there are several apps that use no views at all. We have a new developer
> who wants to use views when writing reports in Crystal Reports. The
> application administrator is leery of using views and ask the DBA group what
> we think. I can see several reasons to use views and a few reasons not to
> use them. I was just wondering what the rest of the group thought.
>
> Ron Smith
> DBA
> Kerr-McGee Corp
> --

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: cjgait_at_earthlink.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).