What else is there in the PLAN apart from the access path?



What else is there in the PLAN apart from the access path?..

Answer / s

The Plan contains the executable SQL code(if DBRMs are
directly bound to the plan) with its access path as well as
the consistency token that will be checked against the
contoken in the load module at execution time.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More DB2 Interview Questions

What are the disadvantages of PAGE level lock?

3 Answers  


difference between group clause and order clause

1 Answers  


What is CHECK PENDING ?

5 Answers  


What is the usage of open cursor command?

0 Answers  


What does db2 plan contain?

0 Answers  






List some fields from sqlca?

0 Answers  


How can record locking be achieved in those DB2 versions which do not support it?

0 Answers  


Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers   IBM,


What is the self-referencing constraint?

2 Answers  


In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)

9 Answers   IBM,


What is the syntax for FETCH in DB2 ?

0 Answers   MCN Solutions,


What are the four lockable units for DB2?

1 Answers  


Categories