Re: One more question SPL optmiser path

Tom Hogarty <hogarty.pad@sni.de> wrote: > Can anybody tell me how to get the optimiser plan out of my > OnLine stored procedures ? Is it permanently stored with the > SPL or must one fiddle with set explain on ? > > Thanks In Advance The execution plan is created at the time the stored procedure is created, it is stored in the system catalog tables, also at the time of UPDATE STATISTICS for any of the tables which are accessed by the stored procedure. You can get the execution plan at the time informix builds the execution plan. Hence: 1) Do 'SET EXPLAIN ON' before running CREATE PROCEDURE OR 2) For stored procedures already in the database: SET EXPLAIN ON; UPDATE STATISTICS . . . .stored_procedure_name Regards, Rafal Czerniawski