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

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

What is the use of db2 optimizer?

Question Posted / prakasha m


What is the use of db2 optimizer?..

Answer / Gulshan Kumar

The DB2 Optimizer is a key component that determines the most efficient way to execute SQL statements by choosing the best access path and query plan. It helps in improving query performance by reducing I/O operations, CPU usage, and network traffic.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

What are data types?

2 Answers  

can we drop column from a table

7 Answers   INDUS,

Can I use LOCK TABLE on a view?

1 Answers  

How many clustering indexes can be defined for a table?

2 Answers  

What else is there in the PLAN apart from the access path?

1 Answers  

How to create a table using embedded sql?

1 Answers  

How to view db2 table structure?

1 Answers  

What is bind in db2?

1 Answers  

what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........

1 Answers  

what is the role of the cursor in db2?

1 Answers  

How does DB2 use multiple table indexes?

1 Answers  

When is the results table for the query in a DECLARE CURSOR statement created?

5 Answers  

For more DB2 Interview Questions Click Here
Categories