Table

 

An SQL table or physical file is the base object for a query. It represents the source of the data used to produce the result set for the query. It is created by the user and specified in the FROM clause (or OPNQRYF FILE parameter).

The optimizer will determine the most efficient way to extract the data from the table in order to satisfy the query. This may include scanning or probing the table or using an index to extract the data.

Visual explain icon:

Table icon

 

Parent topic:

Permanent objects and access methods