The statement concentrator looks for SQL statements that look exactly the same except for their parameter values.
语句集中器寻找除参数值之外完全相同的sql语句。
With the statement concentrator feature, DB2 9.7 now compiles the statement only once to obtain the access plan for the statement, and then reuses it.
现在有了语句集中器特性,DB 2 9.7只编译一次语句就可获得访问计划,然后重用它即可。
DB2 9.7 introduces the statement concentrator feature that improves the performance of programs that use dynamic SQL, and are developed in languages such as Ruby and PHP.
DB 2 9.7引入了语句集中器特性,提高了使用动态sql以及Ruby和php语言开发的程序的性能。
应用推荐