Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: to_number question

Re: to_number question

From: Daniel Fink <Daniel.Fink_at_Sun.COM>
Date: Fri, 16 Jul 2004 08:17:09 -0600
Message-id: <40F7E365.6090505@sun.com>


Wow, what a thread! This is what this list is about. The respectful exchange of ideas, regardless of agreement or disagreement. Someone once said that you learn most from those who disagree with you. (Of course, the occasional dash of humor adds a little spice).

On the subject of subqueries, we must also consider views, which is a subquery with a stored definition. I remember being taught that a view was a logical abstraction and that was it. If we extend the argument that we must consider optimization when executing a subquery, we must do the same for a view. I would venture to guess that there are many more statements using views than coded subqueries. And all the rules of data integrity, performance, optimizer transformation apply. And, yet, how often do we (including anyone who writes code that accesses the database) consider these implications when putting together a view and using in a query.

This is something that requires more thought (from me at least).

Regards,
Daniel Fink



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Fri Jul 16 2004 - 09:14:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US