SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
2-5
Resource Control and Optimization Statements
Resource Control and Optimization Statements
Use these statements to control access to an SQL/MX table and its indexes and to
catalogs on remote nodes:
Control Statements
Use these statements to control the execution default options, plans, and performance
of DML statements:
LOCK TABLE Statement on
page 2-233
Locks the specified table (or the underlying tables of
a view) and its associated indexes for the duration of
the active transaction.
REGISTER CATALOG Statement
on
page 2-241
Registers a catalog on a remote node.
UNLOCK TABLE Statement
on
page 2-308
Releases locks held on the specified nonaudited
table or view.
UNREGISTER CATALOG Statement
on page 2-309
Removes an empty catalog reference from a node.
UPDATE STATISTICS Statement
on
page 2-327
Updates statistics about the contents of a table and
its indexes.
CONTROL QUERY DEFAULT
Statement on page 2-52
Overrides the contents of the SYSTEM_DEFAULTS
table for the current session.
CONTROL QUERY SHAPE
Statement on page 2-54
Forces access plans by modifying the operator tree
for a prepared statement.
CONTROL TABLE Statement
on
page 2-66
Specifies a performance-related option for DML
accesses to a table or view.
SET TABLE TIMEOUT Statement
on
page 2-297
Specifies a dynamic timeout value in the run-time
environment of the current session.