What is a DB2 access path?



What is a DB2 access path?..

Answer / guest

It is used to determine efficient way to access db2 tables.

Is This Answer Correct ?    4 Yes 1 No

Post New Answer

More DB2 Interview Questions

Which component is responsible for processing sql statements and selecting access paths?

0 Answers  


Can you tell me how can you find out the # of rows updated after an update statement?

0 Answers  


Which isolation level provides maximum concurrency?

0 Answers  


What is the difference between Primary key and unique index?

6 Answers  


How to find last record before record through SQLRPGLE?

1 Answers   IBM,






How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement

5 Answers   Syntel,


What is cloudant database?

0 Answers  


Q3. How will you fetch duplicate values from a DB2 table?

2 Answers   RBS,


quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th

5 Answers  


What is an instance database?

0 Answers  


What is COPY PENDING status?

6 Answers  


What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

0 Answers   MCN Solutions,


Categories