It seems to me that you're not dinging views per se here--you're against the
dev's intended use of production data. So if those same SELECT statements
that make up the view were instead baked into the crystal report file & sent
anew every time the report was executed, it'd be the same problem (maybe
worse, since now you're parsing the SQL & planning execution more
frequently?). You buy that?
Cheers,
-Roy
Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487
-----Original Message-----
Sent: Thursday, February 21, 2002 9:09 AM
To: Multiple recipients of list ORACLE-L
IMO views are often used as a substitute for creating reporting
structures.
Using views makes for easy report/SQL creation, but tends to be a
tuning and performance nightmare. It's hard to tune, and will likely
never perform well.
I'm going through similar issues here right now. A number of users
need to do reporting on production data. No way, no how will they
be allowed to do it on the production database. It's a manufacturing
database and performance is critical to this system.
I've done some prototypes of the tables they need to report on. Basically
a copy of the production tables in another database. Those that have a
long refresh cycle ( 1+ days ) get bitmap indexes on most columns. Those
that need to be close to realtime get Btree indexes instead and will be
refreshed every few minutes ( refresh time pending negotiation with users
:).
This is not exactly a data mart as I would like to have it: no star
schemas.
But it's what I have time for right now, gets the reports off of
production and
is *much* faster to query.
HTH
Jared
"Smith, Ron L." <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/21/02 08:18 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Anybody against using views?
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Pardee, Roy E
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).
