If you specify a value for the commit scope, then the procedure might not be able to process all affected rows at once, but it has to count the rows and execute a commit in between.
如果为提交范围指定一个值,那么该过程可能不会立即处理所有受影响的行,但是其间它必须为这些行计数,并执行一个COMMIT。
To avoid this compilation frenzy, it is much more appropriate to move the declaration of the temp into a separate procedure, which is executed once when the workload is started.
为了避免这种疯狂编译,将该临时表的声明移至一个单独过程中会更合适一些,该过程只在启动工作负载时执行一次。
Once you create the SQL procedure that returns a result set, you might want to call it and retrieve the result set.
一旦创建了返回结果集的SQL过程,可能需要调用它并检索结果集。
应用推荐