Re: prepares in 9.2

Posted in 2000

a_blonde@mindless.com — Thu, 11 May 2000 10:14:24 -0400 (EDT) — source: Informix-list mailing list archive (1991-1998)

---- you wrote: > Also, do you know if there is a benefit from preparing sql used > repeatedly in a stored procedure? When sql appears in a stored > procedure, doesn't it automatically save the query plan for future > calls of the routine? If so, preparing sql in a stored procedure would > be useless. But there is no PREPARE command in SPL Dude. Not that I know of. AB ---------------------------------------------------------------- Get your free email from AltaVista at http://altavista.iname.com