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?

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


Please Help Members By Posting Answers For Below Questions

How do I add a column to a table in db2?

1100


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.

3198


What types of tables are there in the db2 database?

1051


What is db2 plan table?

1044


How many databases can be created inside an instance in db2 ?

1029


On which levels locks can be applied?

1121


What is dbrm library?

1045


What is table space in db2?

1014


How do you simulate the explain of an embedded sql statement in spufi/qmf?

1079


What is the role of data manager in the db2 database?

1099


What is lock escalation in db2?

1025


What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1154


List some fields from sqlca?

1054


What is meant by union and union all?

1006


Can we update view in db2?

996