What is an access path?
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 |
Are view updateable?
List down the data types in the db2 database.
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
my project is insurance management system,how to explain my work environment in interview?
How many clustering indexes can be defined for a table?
How do you retrieve the first 5 characters of firstname column of db2 table emp?
what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
Why do chiropractors use drop table?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is a Resource Control Table(RCT)? Describe its characteristics.
WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?
how to unload different table data into different gdg files/ vsam files.