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 host variable in db2 cobol?

1130

Mention the different locking levels that are available in db2.

1183

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1308

What is plan in cobol db2?

1200

How do I delete a table in database?

1075

How do I import data from excel to db2?

1126

What is the use of db2?

1111

Discuss about db2 bind?

1150

What are the contents of dclgen?

1158

What is a bind in db2?

1100

Name the various locking levels available?

1129

Define check constraint.

1125

Explain how can you do the explain of a dynamic sql statement?

1173

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

1117

What is the max length of sqlca?

1266