无需修改程序源代码即可使用经过优化的sql语句替换表现不佳的SQL。

Replace poor performing SQL with a more optimal SQL statement without modifying the program source code.

youdao

图7展示了如何使用一个更好的语句替换一个从Oracle应用程序捕获的SELECT语句。

Figure 7 shows how a SELECT statement captured from an Oracle application can be replaced with a better one.

youdao

需要注意的一个重点是在sql语句中使用以冒号界定的替换操作符。

One important thing to note is the use of the colon delimited replacement operators in the SQL statements.

youdao