If the same INSERT statement is executed repeatedly, its access plan will (usually) be found in the package cache and the compilation cost is avoided.
如果重复地执行相同的insert语句,则该语句的访问计划(通常)会进入到包缓存中,这样就免除了编译的开销。
As a simple example, the following graph (produced by db2exfmt) shows the access plan for an "Insert into Test1 values (?,?,...)".
作为一个简单的例子,下面的图由db 2 exfmt产生展示了“Insert into test1 values?”语句的访问计划。
The JDBC data mediator service generates the appropriate SQL statements (SELECT, INSERT, UPDATE, and DELETE) to access the target data source.
JDBC数据中介服务生成适当的sql语句(SELECT、INSERT、UPDATE和DELETE)来访问目标数据源。
应用推荐