| am_name |
VARCHAR(128) |
Name of the access method |
| am_owner |
CHAR(32) |
Name of the owner of the access method |
| am_id |
INTEGER |
Unique identifying code for an access
method
This corresponds to the am_id columns
in the systables, sysindices, and sysopclasses tables. |
| am_type |
CHAR(1) |
Type of access method:
P = Primary
S = Secondary |
| am_sptype |
CHAR(3) |
Types of spaces where the access method
can exist:
A or a = all types: extspaces,
dbspaces, and sbspaces. If the access method is not user-defined (that
is, if it is built in or registered during database creation by
the server), it supports dbspaces.
D or d = dbspaces only
S or s = sbspaces only (smart-large-object
space)
X or x = extspaces only |
| am_defopclass |
INTEGER |
Unique identifying code for default-operator class
Value is the opclassid from the entry for
this operator class in the sysopclasses table. |
| am_keyscan |
INTEGER |
Whether a secondary access method
supports a key scan
(An access method supports a key scan if it can return a key
as well as a rowid from a call to the am_getnext function.)
( 0 = FALSE; Non-zero = TRUE ) |
| am_unique |
INTEGER |
Whether a secondary access method
can support unique keys
( 0 = FALSE; Non-zero = TRUE ) |
| am_cluster |
INTEGER |
Whether a primary access method supports clustering
( 0 = FALSE; Non-zero = TRUE ) |
| am_rowids |
INTEGER |
Whether a primary access method supports rowids
( 0 = FALSE; Non-zero = TRUE ) |
| am_readwrite |
INTEGER |
Whether a primary access method can
both read and write
0 = access method is read-only
Non-zero = access method is read/write |
| am_parallel |
INTEGER |
Whether an access method supports
parallel execution
( 0 = FALSE; Non-zero = TRUE ) |
| am_costfactor |
SMALLFLOAT |
The value to be multiplied by the
cost of a scan in order to normalize it to costing done for built-in access
methods
The scan cost is the output of the am_scancost function. |
| am_create |
INTEGER |
The routine specified for the AM_CREATE purpose
for this access method
Value = procid for the routine in the sysprocedures table. |
| am_drop |
INTEGER |
The routine specified for the AM_DROP
purpose function for this access method |
| am_open |
INTEGER |
The routine specified for the AM_OPEN
purpose function for this access method |
| am_close |
INTEGER |
The routine specified for the AM_CLOSE purpose
function for this access method |
| am_insert |
INTEGER |
The routine specified for the AM_INSERT purpose
function for this access method |
| am_delete |
INTEGER |
The routine specified for the AM_DELETE purpose
function for this access method |
| am_update |
INTEGER |
The routine specified for the AM_UPDATE purpose
function for this access method |
| am_stats |
INTEGER |
The routine specified for the AM_STATS
purpose function for this access method |
| am_scancost |
INTEGER |
The routine specified for the AM_SCANCOST purpose
function for this access method |
| am_check |
INTEGER |
The routine specified for the AM_CHECK purpose
function for this access method |
| am_beginscan |
INTEGER |
Routine specified for the AM_BEGINSCAN purpose
function for this access method |
| am_endscan |
INTEGER |
The routine specified for the AM_ENDSCAN purpose
function for this access method |
| am_rescan |
INTEGER |
The routine specified for the AM_RESCAN purpose
function for this access method |
| am_getnext |
INTEGER |
The routine specified for the AM_GETNEXT purpose
function for this access method |
| am_getbyid |
INTEGER |
The routine specified for the AM_GETBYID purpose
function for this access method |
| am_build |
INTEGER |
The routine specified for the AM_BUILD
purpose function for this access method |
| am_init |
INTEGER |
The routine specified for the AM_INIT
purpose function for this access method |
| am_truncate |
INTEGER |
The routine specified for the AM_TRUNCATE purpose
function for this access method |