语句集中器寻找除参数值之外完全相同的sql语句。
The statement concentrator looks for SQL statements that look exactly the same except for their parameter values.
现在有了语句集中器特性,DB 2 9.7只编译一次语句就可获得访问计划,然后重用它即可。
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引入了语句集中器特性,提高了使用动态sql以及Ruby和php语言开发的程序的性能。
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.
应用推荐