Re: Procedures and Choosing the QEP

From: Andrew Babb <andrewb_at_mail.com>
Date: Mon, 19 Apr 1999 20:54:16 +0800
Message-ID: <371B2778.F31AC790@mail.com>

Steve,

Within Oracle8, the execution plans are chosen at SQL parse time based upon the statistics (if available) at that time.

Within Oracle8i, it is possible to store executions plans associated with a particular SQL statement.

Andrew

steve_mundie_at_my-dejanews.com wrote:

> I know that procedures are stored compiled but when do the
> execution plans for the statements in them get chosen?
>
> I've had a look through the Oracle8 documentation (I'm running on AIX) but
> can't find this information.
>
> Steve Mundie
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Apr 19 1999 - 07:54:16 CDT