execution plan

From: <markg22003_at_yahoo.com>
Date: Tue, 18 Nov 2008 10:12:40 -0800 (PST)
Message-ID: <a50a1256-a2a7-4b36-9dc7-819724e51e8c@q30g2000prq.googlegroups.com>

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. Received on Tue Nov 18 2008 - 12:12:40 CST

Original text of this message