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...


Plan has the optimized access path in it. But is that
optimized access path is attained or known



Plan has the optimized access path in it. But is that optimized access path is attained or known..

Answer / prajakta

It is attained based on results from RUNSTATS utiliry. The Query Optimizer derives it.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More DB2 Interview Questions

Are views updateable?

0 Answers  


What is a Resource Control Table(RCT)? Describe its characteristics.

3 Answers  


What is -904 sql code? How to resolve it?

3 Answers  


Can we install 2 different versions of Db2 on same mainframe?

3 Answers  


What Utility is used to migrate DB2 from one release to the next?

1 Answers  


What is ibm db2 database?

0 Answers  


could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..

5 Answers  


What is the meaning concurrency in the db2 database?

0 Answers  


what is static sql? what is dynamic sql? Give me details

3 Answers  


What are catalog tables in db2?

0 Answers  


What is db2? Explain.

0 Answers  


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

0 Answers  


Categories