Plan has the optimized access path in it. But is that
optimized access path is attained or known
Answer / prajakta
It is attained based on results from RUNSTATS utiliry. The Query Optimizer derives it.
| Is This Answer Correct ? | 1 Yes | 0 No |
Are views updateable?
What is a Resource Control Table(RCT)? Describe its characteristics.
What is -904 sql code? How to resolve it?
Can we install 2 different versions of Db2 on same mainframe?
What Utility is used to migrate DB2 from one release to the next?
What is ibm db2 database?
could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..
What is the meaning concurrency in the db2 database?
what is static sql? what is dynamic sql? Give me details
What are catalog tables in db2?
What is db2? Explain.
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.