Chapter 14 System Procedures and Functions
969
sa_index_levels system procedure
To assist in performance tuning by reporting the number of levels in an
index.
sa_index_levels ( [
’table_name
’ [ ,
’owner_name
’ ] )
DBA authority required.
None
"CREATE INDEX statement" on page 448
"How indexes work" on page 817 of the book ASA User’s Guide
The number of levels in the index tree determines the number of I/O
operations needed to access a row using the index. Indexes with a small
number of levels are more efficient than indexes with a large number of
levels. You can influence the number of levels in an index using the WITH
HASH SIZE option in the CREATE INDEX statement.
The procedure returns a result set containing the table name, the index name,
and the number of levels in the index.
If no arguments are supplied, levels are returned for all indexes in the
database. If only table_name is supplied, levels for all indexes on that table
are supplied. If table_name is NULL and an owner_name is given, only
levels for indexes on tables owner by that user are returned.
sa_locks system procedure
Displays all locks in the database.
sa_locks ( [
connection
, ][ [
owner
.]
table_name
, ][
max_locks
]
)
DBA authority required.
None
"How locking works" on page 413 of the book ASA User’s Guide
The
sa_locks
procedure returns a result set containing information about all
the locks in the database.
The input parameters are as follows:
connection An integer representing a connection ID. The procedure
returns lock information only about the specified connection. The default
value is zero, in which case information is returned about all connections.
Function
Syntax
Permissions
Side effects
See also
Description
Function
Syntax
Permissions
Side effects
See also
Description
To Next Page
Loading...