Interested to Buy Any Domain ? << Click Here >> for more details...
Plan has the optimized access path in it. But is that
optimized access path is attained or known
- 1 Answers
- 4545 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 SQL Communications Area and what are some of its key fields?
Can there be more than one cursor open for any program?
What are the various locking levels available?
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
What are host variables in db2?
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
What is the use of value function?
What is the difference between spufi and qmf?
How to resolve deadlock issue
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
Highlight all the advantages that are attached to a package.
COBOL 
