Recompile a stored statement.
The compiled form of the precompiled 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 STATISTICSfor a table will also cause a rebuild of statements using that table.
One case where this statement still is useful is after
DELETE STATISTICSwhich 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