ALTER STATEMENT

---

Recompile a stored statement.

Usage

Embedded/Interactive/ODBC/JDBC.

Description

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.

Restrictions

It is only the creator of the statement that may alter it

Example

 ALTER STATEMENT seltaba REFRESH;

Standard Compliance

Standard	Compliance	Comments
	Mimer SQL extension	The ALTER STATEMENT statement is a Mimer SQL extension.

Mimer Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se