Re: Java SQL interface

lakshmi Ashok wrote:
If the DB even makes use of a query plan, in most cases it's the DB itself
that decides upon that.

So, if I use a java prepared statement, there is no confirmation that
the DB may re-use the query plan?

In this case, its as good as using 'Statement' ??

No. Usually the execution plan for a prepared statement is reused. But sometimes it might not be reused. This depends on circumstances, DB vendor and version.

robert

.