Friends:
In Sybase 12.5.3, is the SQL within a stored procedure precompiled and
the query plan stored somewhere (e.g., a package a la DB2 and/or in
the data dictionary)? I'm speaking just of static SQL, BTW.
Basically, I'm wondering if, by default, Sybase reoptimizes a
procedure the first time it's called. Usually one of the benefits if
SPs (beyond encapsulation) is that the SQL has already been parsed and
an execution plan determined.
Is this where abstract plans come in?
Thanks,
--Jeff
|
