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
- 4434 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 do you mean by storage group (stogroup)?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is database alias db2?
What is ibm db2 used for?
What is cursor stability in db2?
What is syscat in db2?
What is page size in db2?
What is rct?
What is the difference between nvl and coalesce?
What is the role of union all and union
What is the use of with ur in db2?
What is check constraint in db2?
What db2 400?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
Can we update view in db2?
