Ron,
Kind of depends on what the view is being used for. I've several examples
of views that are real PIGS with regards to cpu and temp space usage (Sorry, I
can't share them as they belong to a third party application). I've also
eliminated a few of these PIGS, these I could share, by some other database
trickery. My favorite reason NOT to use views is when the view does some data
manipulation based on some strange criteria (been forced into a couple of those
& boy do they create confusion). I'm also not too fond of views whose sole
purpose in life is to rename a column or two from the original table.
Otherwise, to perform common joins and the like, their great.
Dick Goulet
____________________Reply Separator____________________
Author: "Smith; Ron L." <[EMAIL PROTECTED]>
Date: 2/21/2002 8:18 AM
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: Smith, Ron L.
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
