SQL Implementation › Direct Table Access

Direct Table Access

If an access path and the table over which it is based contain the same fields, it is generally more efficient to access data directly from the table rather than through a view. The Database Access Method (YDBFACC) model value and an option on the Edit Access Path Details panel let you specify which method is most appropriate for your environment.

Note: Direct table access is not supported for DRDA (Distributed Relational Database Architecture) Applications.