query about sysprocplan
Posted in 1997
Does anyone know what the following statement means=2E =20 =20 SQL-Reference P2-35 =20 The sysprocplan system catalog table describes the query-execution=20 plans and dependency lists for data-manipulation statements within=20 each stored procedure=2E --THIS BIT -> Because different parts of a=20 procedure plan can be created on different dates, the table can=20 contain multiple rows for each procedure=2E =20 Q=2E How can different parts of a procedure plan be created on=20 different days? =20 TIA Davin ********************************************************************** DST International Tel:+44 181 390 5000 www=2Edstinternational=2Eco=2Eu= k=20 This message and any attachments to it is intended only for the=20 individual or company to which it is addressed and may contain=20 information which is privileged, confidential or prohibited from=20 disclosure or unauthorised use=2E If the recipient of this=20 transmission is not the intended recipient, or the employee or agent=20 responsible for delivering such materials to the intended recipient,=20 you are hereby notified that any use, any form of reproduction,=20 dissemination, copying, disclosure, modification, distribution and/or=20 publication of this e-mail message or its attachments other than by=20 its intended recipient is strictly prohibited by the sender=2E =20 If you have received it in error, please notify us immediately by=20 telephone on the number above and destroy the message and all copies=20 in your possession=2E **********************************************************************