Permanent objects and access methods

There are three basic types of access methods used to manipulate the permanent and temporary database objects -- Create, Scan, and Probe.

The following table lists each object and the access methods that can be performed against that object. The symbols shown in the table are the icons used by Visual Explain.

Table 1. Permanent object data access methods
Permanent objects Scan operations Probe operations
Table Table scan Table probe
Radix index Radix index scan Radix index probe
Encoded vector index Encoded vector index symbol table scan Encoded vector index probe