Re: Execution plan in stored procedures

From: Adrian Bowen <adrian_at_raptor.win-uk.net>
Date: Tue, 22 Jun 1999 06:22:04 +0100
Message-ID: <7kn6jo$8ar$1@laura.pcug.co.uk>

Thanks for the info. I was misled by (or have misinterpreted) the comments made on page 234 of Guy Harrison's "Oracle SQL High-Performance Tuning" book, viz.

'Stored procedures and packages are held within the database in a compiled form. This means that all the SQL within the stored procedure has already been parsed. When the SQL statement is executed, there is no need to check the statement for syntax, object references or to determine the execution plan.'

Regards

Adrian Received on Tue Jun 22 1999 - 00:22:04 CDT