Re: statspack report shows low execute to parse%

Dynamic SQL is SQL generated at runtime and has to be parsed. Static SQL used to be the term used in the Oracle Pro*c for prepared SQL which should allow the reuse of SQL build using bind variables. I think I got this right. You want to use prepared SQL statements build with bind variables and avoid dynamic SQl whenever possible.

• Mark D Powell --