Pathmaker Reference Manual
Table Access Paths Screen
Pathmaker Screens
1–198 067869 Tandem Computers Incorporated
Table Access Paths
Screen
Use the Table Access Paths screen to define and manage access paths for the current
SQL table. Access paths are optional attributes of SQL table objects. An access path
identifies an ordered set of columns of the table for SELECT and FETCH operations.
Each table object can have up to 40 named access paths.
When you add a base table or protection view to the project catalog using the
Pathmaker screens or PMADL, the Pathmaker product attempts to create default
access paths corresponding to each of the associated indexes. (No default access paths
are created for shorthand views.) The following rules apply:
1. A unique access path is created on the primary key columns (including SYSKEY
when appropriate). The path name is PRIMARY-KEY.
2. A unique access path is created on the index columns for each unique index.
3. If the primary key is visible and uniform, one non-unique access path is created on
the index columns for each non-unique index that is visible, non-nullable, and
uniform with the primary key.
You can rename, modify, or delete the default paths as well as add new ones. Access
paths are not required to correspond to existing indices on the table.
052
T A B L E A C C E S S P A T H S
==============================================================================
Table Name: PERSON
Access Path Name: PERSON-BY-ZIP-NAME___________________
Default: _ (Y/N) Unique: (Y/N)
Efficient:
Description: ________________________________________
Column Names
ZIP___________________________
LAST NAME_____________________
FIRST NAME____________________
______________________________
______________________________
______________________________
______________________________
______________________________
______________________________
______________________________
==============================================================================
F1-Add F2-Update F4-List F6-Insert Line F9-Value List
SF2-Delete F5-List Next SF6-Delete Line
BLOCK
Displaying the Screen You reach the Table Access Paths Screen from the SQL Table Registration screen by
pressing F7 when the cursor is positioned on an entry for an existing table object.