How Plan is created while executing the query using SPUFI?
Answer Posted / arun chinnadurai
A package/plan is created is created for DB2I tools and the
authorization to execute that plan is given to Public.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
Can one database have multiple instances?
what is the responsibility of the construction superintendent
What action db2 takes when a program aborts in the middle of a transaction?
What is copy pending and check pending in db2?
What are union and union all?
How is deadlock resolved?
Is db2 a mainframe database?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is the function of logging in the db2 database?
What is difference between isnull and coalesce?
What is the maximum No of rows per page?
What are the contents of a dclmgen?
What is db2 stogroup?
What is a db2 schema?