VTIEnvironment is the state variable created by the optimizer to help it place a Table Function in the join order. The methods of VTICosting use this state variable in order to pass information to each other and learn other details of the operating environment.
org.apache.derby.vti.VTICosting
| Modifier and Type | Method and Description |
|---|---|
| public String | Returns: the SQL text of the original SQL statementReturn the SQL text of the original SQL statement. |
| public Object | Returns: the value associated with the keyKey into a cache of context variables key)Get an object associated with a key from set of objects maintained with the statement plan. |
| public int | Returns: the specific JDBC isolation of the statementGet the specific JDBC isolation of the statement. |
| public boolean | Returns: true if this instance of the Table Function has been created for compilationReturn true if this instance of the Table Function has been created for compilation, false if it is for runtime execution. |
| public void | setSharedState(String
Key into a cache of context variables key, Serializable Value to associate with the key value)Saves an object associated with a key that will be maintained for the lifetime of the statement plan. |
| getOriginalSQL | back to summary |
|---|---|
| public String getOriginalSQL() Return the SQL text of the original SQL statement.
| |
| getSharedState | back to summary |
|---|---|
| public Object getSharedState(String key) Get an object associated with a key from set of objects maintained with the statement plan. | |
| getStatementIsolationLevel | back to summary |
|---|---|
| public int getStatementIsolationLevel() Get the specific JDBC isolation of the statement. If it returns Connection.TRANSACTION_NONE then no isolation was specified and the connection's isolation level is implied.
| |
| isCompileTime | back to summary |
|---|---|
| public boolean isCompileTime() Return true if this instance of the Table Function has been created for compilation, false if it is for runtime execution.
| |
| setSharedState | back to summary |
|---|---|
| public void setSharedState(String key, Serializable value) Saves an object associated with a key that will be maintained for the lifetime of the statement plan. Any previous value associated with the key is discarded. Any saved object can be seen by any JDBC Connection that has a Statement object that references the same statement plan.
| |