Re: execution plan

markg22003_at_yahoo.com wrote:
> ORACLE 8i (we are in process of upgrading to 10g).
>
> UNIX solaris 5.8 (we are moving to new box).
>
> optimizer_mode = choose
>
>
> Does anyone know if the size of the temp tablespaces is used to create
> an execution plan ?
>
> If we significantly increased its size, could the execution plan
> change ?
>
> Thank you.

It should be irrelevant except should you run out of space.

The size could affect speed but it should not affect the plan.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org