Answer Posted / 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 |
Post New Answer View All Answers
How do I add a column to a table in db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What types of tables are there in the db2 database?
What is db2 plan table?
How many databases can be created inside an instance in db2 ?
On which levels locks can be applied?
What is dbrm library?
What is table space in db2?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is the role of data manager in the db2 database?
What is lock escalation in db2?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
List some fields from sqlca?
What is meant by union and union all?
Can we update view in db2?