Plan has the optimized access path in it. But is that
optimized access path is attained or known
- 1 Answers
- 4118 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / prajakta
It is attained based on results from RUNSTATS utiliry. The Query Optimizer derives it.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the latest version of ibm db2?
What is db2 bind process?
What is cursor with hold option in db2?
How can you find out the # of rows updated after an update statement?
How is deadlock resolved?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is the maximum size of a char data type in db2?
What does db2 blu stand for?
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.
Explain various types of locks in db2?
What is db2? Explain.
What is data manager?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
Which is faster delete or truncate?
What is scrollable cursor in db2?
