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 / s

The optimizer will determine all the different access paths
for the query and does a cost-based analysis and chooses
the the least expensive path.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about cursor stability?

1100


What is check constraint in db2?

1162


What is the maximum size of varchar data type in db2?

1172


What is the difference between drop table and delete table?

1278


What is a page in db2?

1069


What is the physical storage length of time data type?

1173


What is meant by union and union all?

1051


What is release/acquire in bind?

1152


What is a Foreign Key?

1137


What are the full forms of spufi and dclgen and why are they used?

1136


What is an instance database?

1092


What is the use of value function?

1201


Give a brief description of db2 isolation levels?

1132


How to retrieve rows from a db2 table in embedded sql?

1438


How and when does the db2 enforces the unique key?

1137