The method that is selected by the optimizer 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.
A description of the route that the File Manager follows to access a file; created when a file is opened See also: file reference number
The path selected by the database management system to locate and retrieve requested data.
a path that a user looks along in accessing linked content portions by judging from one content portion forward or backward to another linked content portion
Refers to how data from a SQL statement is retrieved such as an index.
The algorithm used by the ORACLE Server to locate data within a database. When the optimizer parses a SQL statement it evaluates possible access paths in order to use the best access path. To some degree, users can help the optimizer choose an access path through deliberate wording of SQL statements.
The logical route an end user takes to access computerized information. Typically, it includes a route through the operating system, telecommunications software, selected application software and the access control system.
The path chosen by a database management system to retrieve the requested data.
The complete route, including the drive letter, directory, and all sub-directories, that directs an operating system to a file or application in a storage device. For example, the access path C:\WlNDOWS\SYSTEM\crmscip indicates that the crmscip file is stored in the SYSTEM sub-directory in the WINDOWS directory, which is on the C: drive. Also called directory path.