Answer Posted / vira raguram.i
a plan is an executable module containing the access path
logic produced by the db2 optimizer.it can have one or more
DBRMs or packages.
Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
What's The Error Code For Unique Index Voilation?
What is the role of the data page in the db2 database?
Explain about rct in db2?
Why cursor is used in db2?
Mention the location where the output received from explain statement is stored.
What is the use of db2 optimizer?
What is a bind in db2?
How is deadlock resolved?
what is the sqlcode -501
What is db2 instance?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is database reorganization?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
How do you select a row using indexes in db2?
What is the usage of open cursor command?