The dynamic SQL is prepared at run time and the access path is determined

When is the access path determined for dynamic SQL?

Question Posted / s

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

How to view db2 table structure?

1065

How do I delete a column in db2?

1154

What is the difference between nvl and coalesce?

1107

What are foreign keys in db2?

1170

How to restart a DB2 program?

1956

Explain packages.

1169

What is the use of runstats in db2?

1178

Comment whether the cursor is closed during commit or not.

1169

what is the responsibility of the construction superintendent

2209

When reorg is used?

1182

How to execute stored procedures?

1175

What is the use of commit in db2?

1140

What is declare cursor?

1169

What is check constraint. Explain with example.

1162

Can you tell me how can you find out the # of rows updated after an update statement?

1144