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 |
Which component is responsible for processing sql statements and selecting access paths?
Can you tell me how can you find out the # of rows updated after an update statement?
Which isolation level provides maximum concurrency?
What is the difference between Primary key and unique index?
How to find last record before record through SQLRPGLE?
How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement
What is cloudant database?
Q3. How will you fetch duplicate values from a DB2 table?
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
What is an instance database?
What is COPY PENDING status?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?