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
- 4453 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 result of open cursor statement?
What are the two types of logging in the db2 database? Explain them.
How to find the maximum value in a column in the db2 database?
How would you find out the total number of rows in a db2 table?
What is dbrm? When it will be created?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
Describe major components of db2?
What is access path in db2?
What is a collection in db2?
Before you give the explain statement, what are the prerogatives?
What is the advantage in De-normalizing tables in DB2?
What is syscat in db2?
How many databases are there?
What is a buffer in memory?
