prepare SPL

jvemo@cyberspace.com (Jon C. Vemo) writes: >I know that any SQL statement to executed more than once or twice, benefits >from having the statement prepared first. Does this also apply to "execute >procedure <sp_name>". Are there any benefits or reasons not to prepare an >execute procedure statement??> >TIA >Jon >==================================================== >Jon Vemo Internet: jvemo@cyberspace.com >Bothell, WA USA > >Watch out for road-kill on the information superhighway....SPLAT!! >==================================================== > I don't know for a fact, but I would not think so, since the SPL lives on the server, as long is it a valid SPL, there should be nothing to optimize as there is with a regular , unprepared DML statement. It is optimized when you first create the procedure.