hello *,
i am connecting to SAPDB using JDBC and PreparedStatements that are
parameterized ('?' and setXXX()).
Question: what does the optimizer with constant values in a prepared
statements? does the optimizer run when i .prepare() a statement? does
it run later?
does it make a difference wether i "SELECT ... WHERE foo > 3" or "SELECT
... WHERE foo > ?" (and set the 3 as parameter)?
thanks for any hint,
Raimund
--
Raimund Jacob
\|/ ____ \|/
Pinuts Media+Science GmbH "@'/ ,. \`@"
Potsdamer Str. 96 /_| \__/ |_\
D-10785 Berlin \__U_/
http://www.pinuts.de/ voice: +49 30 590090313 fax: +49 30 590090390
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
