Interested to Buy Any Domain ? << Click Here >> for more details...
What is an access path?
- 3 Answers
- 6786 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 |
What is innodb buffer pool?
Where to download IBM DB2 Certification Dumps for the below: C2090-311 : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-312 : IBM DB2 11 DBA for z/OS C2090-313 : DB2 11 Application Developer for z/OS C2090-317 : DB2 11 System Administrator for z/OS C2090-541 : DB2 9.7 DBA for Linux UNIX and Windows C2090-543 : DB2 9.7 Application Development C2090-544 : DB2 9.7 Advanced DBA for LUW C2090-545 : DB2 9.7 SQL Procedure Developer C2090-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-610 : DB2 10.1 Fundamentals C2090-611 : DB2 10.1 DBA for Linux, UNIX, and Windows C2090-612 : DB2 10 DBA for z/OS C2090-614 : DB2 10.1 Advanced DBA for Linux UNIX and Windows C2090-615 : DB2 10.5 Fundamentals for LUW C2090-617 : DB2 10 System Administrator for z/OS C2090-730 : DB2 9 Family Fundamentals C2090-733 : DB2 9 Application Developer C2090-735 : DB2 9.5 SQL Procedure Developer C2090-737 : DB2 9 System Administrator for z/OS Exam
What are the uses of db2 optimizer?
What is COPY PENDING status?
How do I copy a table in db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What are the Isolation levels possible ?
What is ibm db2 database?
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
What's the Maximum Length of SQLCA and what's the content of SQLCABC?
which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
Which isolation level provides highest data integrity?
COBOL 
