Was this helpful?
Repeated Queries
The keyword REPEATED directs the DBMS Server to encode the insert and save its execution plan when it is first executed. This encoding can account for significant performance improvements on subsequent executions of the same insert.
Do not specify the REPEATED option for INSERT statements that are constructed using dynamic SQL. A dynamic WHERE clause cannot be used in a repeated insert: the query plan is saved when the query is first executed, and subsequent changes to the WHERE clause are ignored.
Last modified date: 02/03/2024