What Is The Difference Between Access Path And Dynamic Select?

1.	What Is The Difference Between Access Path And Dynamic Select?
Answer» Dynamic SELECT OCCURS whenever the program reads FILE. But ACCESS PATH occurs before the file is read (but not necessarily). Dynamic select occurs whenever the program reads file. But access path occurs before the file is read (but not necessarily).

Answer»

Dynamic SELECT OCCURS whenever the program reads FILE. But ACCESS PATH occurs before the file is read (but not necessarily).

Dynamic select occurs whenever the program reads file. But access path occurs before the file is read (but not necessarily).

Discussion