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 -> tuning sql statement with bind value

tuning sql statement with bind value

From: Mike F <u518615722_at_spawnkill.ip-mobilphone.net>
Date: Fri, 25 Jan 2002 16:35:18 GMT
Message-ID: <l.1011976519.1981536865@[64.94.198.252]>


I am learning the most difficult part of performance tuning. Almost all of our sql statement use bind values. With binding variables in your sql statement, oracle does not allow you to explain plan, should i just change the sql, hard code it and explain it and believe that oracle will use the same execution path as the binding one?

How about histograms?
Thanks for you help.  

-- 
Sent by  dbadba62  from hotmail subpart  of com
This is a spam protected message. Please answer with reference header.
Posted via http://www.usenet-replayer.com/cgi/content/new
Received on Fri Jan 25 2002 - 10:35:18 CST

Original text of this message

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