WHAT IS EXPLAIN?

Varun Agrawal

Total Post:159

Points:795
Posted by  Varun Agrawal
DB2 
DB2
 1179  View(s)
Ratings:
Rate this:
  1. Varun Agrawal

    Post:159

    Points:795
    What is EXPLAIN?

    EXPLAIN is used to display the access path as determined by the optimizer for a SQL statement. It can be used in SPUFI (for single SQL statement ) or in BIND step (for embedded SQL ).

  1. satish yedida

    Post:2

    Points:10
    What is EXPLAIN?

    Addition to Varun:  Explain utility using several  tables for storing accesspath information. The main tables are :

    1. Plan table : It stores the access path information.

    2. Dsn statement table : It stores cost estimation information.

    3. Dsn function table : It stores user defined function if explain using such functions.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!