Plan has the optimized access path in it. But is that
optimized access path is attained or known
- 1 Answers
- 4093 Views
- IBM, I also Faced
- E-Mail Answers
Answer / prajakta
It is attained based on results from RUNSTATS utiliry. The Query Optimizer derives it.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the advantage in De-normalizing tables in DB2?
What happens in bind step in a db2 program?
Is it possible using max on a char column?
What is the difference between nvl and coalesce?
what is difference between Plan and Package
What is the use of reorg in db2?
What is db2?
How to connect to db2 database from windows command line?
What is rct?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
What is the result of open cursor statement?
what are stage one indexable predicates?
COBOL 
