Re: Re[2]: to_number question

From: Raj Jamadagni <rjamya_at_yahoo.com>
Date: Mon, 19 Jul 2004 04:01:36 -0700 (PDT)
Message-ID: <20040719110136.6652.qmail@web50009.mail.yahoo.com>

• jaromir nemec <jaromir_at_db-nemec.com> wrote:
  >
  >
  > Simple the DBMS will suppress any ORA-nnnnn error and will try in a loop the
  > next access path. May be next time the query will be successful!
  >
  > How many time this loop on different execution plans should be repeated? Why
  > not limit it with OPTIMIZER_MAX_PERMUTATIONS:)
  >
  

I disagree, this approach will bring out more issues with query performance. Plus how will the rdbms *know* what results you want to keep trying to please you? Maybe I *want* the rdbms to error out on the first invalid datum as it does now. So, if there are any issues I'd like to know now rather than tomorrow when it comes back with 15 rows and 25000 invalid rows after traversing 80000 different paths of execution. JWOR ... Just waste of Resources.

Cheers
Raj

---

Best Regards
Raj

---

select mandatory_disclaimer from company_requirements;

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

---

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 Mon Jul 19 2004 - 05:58:11 CDT