sumithra devi asked: > We have sql query that is generated dynamically(this is what > is causing teh problem)
I'm no expert in tuning database access, but even for a one-time use, Oracle can do a better job if you use a PreparedStatement rather than a Statement. Of course, if you can re-use that PreparedStatement SQL, Oracle can gain a lot more from its optimizations. - George --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
