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 |
What are the disadvantages of PAGE level lock?
difference between group clause and order clause
What is CHECK PENDING ?
What is the usage of open cursor command?
What does db2 plan contain?
List some fields from sqlca?
How can record locking be achieved in those DB2 versions which do not support it?
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.
What is the self-referencing constraint?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
What is the syntax for FETCH in DB2 ?
What are the four lockable units for DB2?