Re: WHY SQL-Statement without bind-prameters runs 50 times faster as with ??????

Hello!
I have read this in an OracleTuningBook too, the Problem is that Oracle does not know the datatype of an bind and so strict search with index seems not possible. The Statements i showed are outputs from tkprof.

So in Oracle 8.1.6 Oracle uses automatically bindparam by parsing the statement with constant expressions. Probably the need for bind-params will descrease!

Regards

Karl Reitschuster
Senior Consultant CSC Ploenzke AG
Oracle Databases, Implementation, Performance-Tuning <!Jesus is Lord!>
* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free! Received on Thu May 04 2000 - 00:00:00 CDT