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

What is cursor stability in db2?

1293

What are the various data types available in db2?

1024

Explain about mirror activator disk mirroring?

968

What is ibm db2 client?

890

What is explain in db2?

972

What is the maximum No of rows per page?

1021

How can deadlocks be resolved?

899

What is db2 instance?

1030

What is performance tuning db2?

1018

Explain the benefits you can get from mainframe connect?

920

What is db2 and what is the use of db2 optimizer?

1003

What is null indicator in db2?

1056

How do I add a column to an existing table in db2?

981

What is image copy in db2?

955

Which component is used to execute the sql statements?

1061