Re: query about sysprocplan

davin_harvey@dsti.co.uk wrote: > > 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? The dependency lists and other non-optimizer related records are created when the procedure is created but the query plan is create with the stored procedure but will be replaced when you UPDATE STATISTICS FOR PROCEDURE.... or when a automatic reoptimization gets triggered. Art S. Kagel