The optimizer will determine all the different access paths for the query

What will the DB2 optimizer do?

Question Posted / s

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

Please Help Members By Posting Answers For Below Questions

How do you pull up a query which was previously saved in qmf?

1134

What is db2 and what is the use of db2 optimizer?

1030

What do you mean by cursor?

976

Is schema the same as database?

1042

What is syscat in db2?

982

What is the max length of sqlca?

1206

What is cursor with hold option in db2?

1052

What is the connection string to connect to the DB2 Database ?

1089

Is db2 a database?

945

Define declaration generator (dclgen).

1097

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1067

What is netezza database?

997

What is performance tuning db2?

1045

Why db2 is called db2?

1008

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1057