When is the access path determined for dynamic SQL?
Answer Posted / s
The dynamic SQL is prepared at run time and the access path
is determined at execution time. Dynamic SQL changes from
one execution to another.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the physical storage length of time data type?
How to find the number of rows in a db2 table?
What is difference between alias and synonym in db2?
Can you tell me how can you find out the # of rows updated after an update statement?
How to restart a DB2 program?
What is drop table?
What is runstats and reorg in db2?
Comment whether the cursor is closed during commit or not.
What is syscat in db2?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
define clustering index.
What is cursor stability in db2?
What are the different types of base tables?
What is ibm db2 client?
How can record locking be achieved in those DB2 versions which do not support it?