Recompile a stored statement.
The compiled form of the executable statement is replaced with the result of a new compilation.
It is only the creator of the statement that may alter it.
The use for this statement is diminished since automatic statement refresh has been implemented. That is, when creating or dropping an index for a table, all statements using that table are automatically refreshed. Likewise, UPDATE STATISTICS for a table will also cause a rebuild of statements using that table. One case where this statement is useful is after DELETE STATISTICS which will not cause an automatic refresh of statements.
ExampleALTER STATEMENT seltaba REFRESH;
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40