When is the access path determined for dynamic SQL?

Answers were Sorted based on User's Feedback



When is the access path determined for dynamic SQL?..

Answer / s

The dynamic SQL is prepared at run time and the access path
is determined at execution time. Dynamic SQL changes from
one execution to another.

Is This Answer Correct ?    3 Yes 0 No

When is the access path determined for dynamic SQL?..

Answer / kamalakar

At runtime when the PREPARE statement is issued.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is concurrency?

0 Answers  


Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?

1 Answers  


What is the difference between drop table and delete table?

0 Answers  


Can any one tell me about Restart logic in DB2.

2 Answers  


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

0 Answers  


What are the contents of a DCLGEN?

4 Answers   MetLife,


How is deadlock resolved?

0 Answers  


define clustering index.

0 Answers  


What is reorg in database?

1 Answers  


Are views updateable?

0 Answers  


Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?

1 Answers  


What is db2 connect?

0 Answers  


Categories