Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


What is an access path?

Answers were Sorted based on User's Feedback



What is an access path?..

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

What is an access path?..

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

What is an access path?..

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

Post New Answer

More DB2 Interview Questions

Explain correlated sub-queries.

0 Answers  


if i made sme changes in sub pgm wht r the things to be done for this ?

1 Answers   TCS,


What is database alias db2?

0 Answers  


What is the SQL query to select, delete and get count of duplicate rows in DB2?

2 Answers  


What is the max length of sqlca?

0 Answers  


in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?

3 Answers   Infosys,


How to resolve -407 sql code in DB2?

9 Answers   Cap Gemini,


wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,


Define predicate?

0 Answers  


What is rebind in db2?

0 Answers  


what are the max. & min. no. of partitions allowed in a partition tablespace?

2 Answers   IBM,


What happens to a cursor after a commit?

3 Answers  


Categories