Recompile a stored statement.
The compiled form of the executable statement is replaced with the result of a new compilation. This can be used to change the query plan after adding or dropping an index or when new statistics data has been gathered.
It is only the creator of the statement that may alter it
ExampleALTER STATEMENT seltaba REFRESH;
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40