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
- 4617 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 db2 bind?
What is the difference between spufi and qmf?
How is deadlock resolved?
What is database manager in db2?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
Why do we use cursor?
What is the use of value function?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is a buffer in memory?
How and when does the db2 enforces the unique key?
What is the difference between using bind () and rebind () methods of naming class?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
How to connect to db2 database from windows command line?
How can you quickly find out the # of rows updated after an update statement?
What is the role of schema in the db2 database?
