You can optimize the execution of SQL in CA Ideal applications, either embedded SQL or SQL generated by FOR constructs, by using an application plan that can execute the SQL in static mode. You can execute SQL not executed as part of an application plan in CA Ideal in dynamic mode. Generally, a program is tested in dynamic mode and, when it is ready for performance testing or production, it is moved into static mode.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|