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

Home -> Community -> Usenet -> c.d.o.server -> Re: optimizer and bind variables

Re: optimizer and bind variables

From: Steffen Ramlow <s.ramlow_at_gmx.de>
Date: Wed, 27 Mar 2002 08:55:35 +0100
Message-ID: <a7s5gr$o0f2r$1@ID-54600.news.dfncis.de> 





> When you have literals you are giving the optimizer more information to

> work with.  In 9i, the optimizer can "take a glance" at the value of

> bind variables under certain circumstances




are u sure? where is this documented?


and btw: i'm using 8.1.7
Received on Wed Mar 27 2002 - 01:55:35 CST












Original text of this message













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