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 will the DB2 optimizer do?

Answer Posted / srinivas yadav

OPTIMIZER: IT CHOOSES THE BEST ACCESS PATH.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

On which levels locks can be applied?

1058


What is access path in db2?

923


What db2 400?

1099


What's The Percentage Free Space ?

1156


What is meant by explain?

1058


What is the difference between drop table and delete table?

1116


How to find primary key of a table in db2?

1001


What is the physical storage length of timestamp data type?

1022


Why do we use cursor?

1045


Which command is used to remove all rows from a table?

1037


What is concurrency?

1147


What is buffer pool in the db2 database?

1046


Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1134


What are the contents of a dclmgen?

1066


What is performance tuning db2?

1003