RE: views on views on views
- From: "Stephens, Chris" <chris_stephens@xxxxxxxxxxxx>
- To: <ganstadba@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 26 Mar 2009 12:52:03 -0500
Gangsta,
I have yet to see the abuse of the with clause. I have only come across
situations where it would help with both performance and readability.
Just last week I was able to re-write some sql to make use of a with
clause. It dramatically improved performance and gave me an opportunity
to send the developers some links to the documentation and askTom.
Unfortunately, we have people that will find a way to abuse it.
The most recent abuse of oracle functionality I've come across came
after one of the developer's learned of the table function. All of a
sudden table functions started popping up all over the place.
Unbelievable...and weird.
Mosly I just wanted to write gangsta in an email to oracle-l.
Chris
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Michael McMullen
Sent: Thursday, March 26, 2009 11:58 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: views on views on views
I have one group that loves views but also loves the "with" statement.
So it's views on top of views on top of "with" statements on top of
"with" statements.
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Carol Dacko
Sent: Thursday, March 26, 2009 11:49 AM
To: chris_stephens@xxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: views on views on views
Dear Chris,
We feel your pain! It is pervasive in our environment. Security views
I can understand, but views, on views, on views, is just a nightmare.
Dan Tow just did a great talk at the HOTSOS Symposium, "Safe Use of
Views? Just Say "No"? ". Dan Tow also has a featured article on his
website called Views, From Forty-Thousand Feet. The link is here:
http://www.singingsqlcom/newsletter07.htm
<http://www.singingsql.com/newsletter07.htm>
The first paragraph hits the nail on the head:
"
CONFIDENTIALITY NOTICE:
This message is intended for the use of the individual or entity to
which it is addressed and may contain information that is privileged,
confidential and exempt from disclosure under applicable law. If the reader of
this message is not the intended recipient or the employee or agent responsible
for delivering this message to the intended recipient, you are hereby notified
that any dissemination, distribution or copying of this communication is
strictly prohibited. If you have received this
communication in error, please notify us immediately by email reply.
Other related posts:
