Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


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
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX