Releasing a scope definition (RELEASE SCOPE statement)
To release a scope definition, use the RELEASE SCOPE statement. This statement releases a scope definition that
was applied to a user by the APPLY SCOPE statement.
The statements "RELEASE SCOPE" and "APPLY SCOPE" must be executed by the same user.
An example of using the RELEASE SCOPE statement follows.
Example:
Release the scope "OSAKA_SCOPE" that is currently applied to user "SUZUKI."
Deleting a user scope (DROP SCOPE statement)
To delete a scope definition, use the DROP SCOPE statement. This statement deletes a scope definition that was
applied to a user by the APPLY SCOPE statement.
The statements "DROP SCOPE" and "CREATE SCOPE" must be executed by the same user.
An example of using the DROP SCOPE statement follows.
Example:
Delete scope TOKYO_SCOPE.
3.1.3 Defining optimization information for added definitions (SET STATISTICS
statement)
If a table and index are added, use the SET STATISTSICS statement to define optimization information for them. An
example of the SET STATISTICS statement follows.
Example:
Define optimization information about an added TOKAI_ORDER _DSI.
129