What will the DB2 optimizer do?

Question Posted / guest

Answers were Sorted based on User's Feedback

What will the DB2 optimizer do?..

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

What will the DB2 optimizer do?..

Answer / srinivas yadav

OPTIMIZER: IT CHOOSES THE BEST ACCESS PATH.

Is This Answer Correct ?

2 Yes

0 No

More DB2 Interview Questions

What is bind plan?

What is the command used by TSO users to invoke DB2?

Where would you find information about the type of database authority held by the user?

What is the cobol picture clause of the db2 data types date, time, timestamp?

What is the maximum size of a char data type in db2?

Explain an outer join?

How will you return the number of records in table?

What is syscat in db2?

List out the data types available.

i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

How will fetch last 5 rows from table in db2

In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?

For more DB2 Interview Questions Click Here