Interested to Buy Any Domain ? << Click Here >> for more details...
What is an access path?
- 3 Answers
- 6646 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / abhishek kale
Access Path is the path chosen by the DB2 Optimizer to
retrieve the data from a table in the most efficient manner.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / anuj tiwari
The order in which the database fields are organized for processing in the program.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / guest
Access path used to give u the best path to access the data
in the DB2 table...
| Is This Answer Correct ? | 0 Yes | 1 No |
How to resolve -504 sql code in DB2?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is reorg and runstats in db2?
What is a PLAN table? How will you use it? Give the various fields of PLAN table?
what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'
What is db2 optimizer?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
How can you compare table column after update and before update?
What is dbrm? When it will be created?
Explain dclgen.
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
Explain in brief how does db2 determine what lock-size to use?
COBOL 
