January 2005
Beginner to intermediate
928 pages
22h 14m
English
The method that the database manager selects for retrieving data from a specific table. For example, an access path can involve the use of an index, a sequential scan, or a combination of the two.
The set of access paths that the optimizer selects to evaluate a particular SQL statement. The access plan specifies the order of operations to resolve the execution plan, the implementation methods (such as JOIN), and the access path for each table referenced in the statement.
Contains information a client workstation needs to catalog a remote database stored on a DB2 UDB server.
An object that describes the security context of a process or thread. The information in the token includes the identity ...
Read now
Unlock full access