Overview and Usage of EXPLAIN

This section provides the usage and format of EXPLAIN along with examples.

EXPLAIN lists the files, indexes, sorts etc., that are included in the command along with the access timings in a report format to understand what is happening.

Only jQL commands are covered in TAFC.

The report does not generate all the details available for each group. It is more like a prototype intended to demonstrate what sort of information can be returned. The mechanism needed to access this information is available and can be expanded.

The format of EXPLAIN is given below.

EXPLAIN <<Command>>