46) Where is the output of EXPLAIN stored? –
In userid.PLAN_TABLE
47) EXPLAIN has output with MATCHCOLS = 0. What does it mean? –
a nonmatching index scan if ACCESSTYPE = I.
48) How do you do the EXPLAIN of a dynamic SQL statement?
1. Use SPUFI or QMF to EXPLAIN the dynamic SQL statement
2. Include EXPLAIN command in the embedded dynamic SQL statements
49) How do you simulate the EXPLAIN of an embedded SQL statement in
SPUFI/QMF? Give an example with a host variable in WHERE clause.)
Use a question mark in place of a host variable ( or an unknown value ).
e.g.
SELECT EMP_NAME
FROM EMP
WHERE EMP_SALARY > ?
50) What are the isolation levels possible ? –
CS: Cursor Stability
RR: Repeatable Read
|