8. SQL Statements : SELECT (embedded) : Non-Cursor Select : REPEATED Queries
 
Share this page                  
REPEATED Queries
To reduce the overhead required to repeatedly execute a SELECT query statement, specify the query as REPEATED. For repeated queries, the DBMS Server saves the query execution plan after the first time the query is executed. This can significantly improve the performance of subsequent executions of the same select.
If your application needs to be able to change the search conditions, dynamically constructed search conditions cannot be used with repeated queries. The saved execution plan is based on the initial value of the search condition and subsequent changes are ignored.