Re: execution plan of a stored procedure

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 10 Jan 2005 07:02:23 -0800
Message-ID: <41e297d4$1_1@127.0.0.1>

roark wrote:

> hi,
>
> A stored procedure is said to be 'pre-compiled'. In oracle 9i, is the
> execution plan of the stored proc part of this compiling process? I
> mean, if the CBO statistics change, will the stored procedure still
> retain the old plan?
>
> thanks,
> roark

Stored procedures don't have execution plans ... SQL statements have execution plans. And no they are not stored.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---

Received on Mon Jan 10 2005 - 09:02:23 CST