The following table shows characteristics of CA 2E access paths:
|
Access Path Type |
Real Fields |
Key Fields |
Virtual Fields |
Virtual Keys |
|
PHY (Physical) |
Yes |
No |
No |
No |
|
UPD (Update) |
Yes |
Relation |
No |
No |
|
RTV (Retrieval) |
Yes |
Relation |
Yes |
No |
|
RSQ (Resequence) |
Yes |
User |
Yes |
No |
|
QRY (Query) |
Yes |
User |
Yes |
Yes |
|
SPN (Span) |
Yes |
User |
Yes |
No |
|
Copyright © 2014 CA.
All rights reserved.
|
|