how to parse only once for multiple executions of the same statment
Posted: Fri 17 Mar 2006 15:47
Is there a way to parse a statement only once for multiple executions of the same statement? I have an insert statement that I use multiple times in a single transaction and have found in the trace file that it is parsed once for each time that it is called.
This is a serious issue because this could cause severe slowdowns in our production system where the statement is likely to be called several thousand times.
Any help would be greatly appreciated!
-HP
This is a serious issue because this could cause severe slowdowns in our production system where the statement is likely to be called several thousand times.
Any help would be greatly appreciated!
-HP