Access Path is the path chosen by the DB2 Optimizer to retrieve the data

What is an access path?

Question Posted / abhishek kale

Answer Posted / abhishek kale

Access Path is the path chosen by the DB2 Optimizer to
retrieve the data from a table in the most efficient manner.

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is precompiler in db2?

992

What is db2 optimizer?

1214

What is the physical storage length of date data type?

1229

Explain the contents that are a part of dclgen.

1071

What are bind parameters in db2?

1020

How does coalesce work?

997

List down the data types in the db2 database.

1095

What is db2 bind?

1052

can all users have the privilage to use the sql statement select * (dml)?

1143

Which are the db2 tools to protect integrity of the database?

1105

What is the difference between bind and rebind in db2?

1425

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

1040

How many types of page locks can be held in db2?

1020

What is isolation level in db2?

978

What is the max length of sqlca?

1206