temp tablespace

From: <markg22003_at_yahoo.com>
Date: Tue, 18 Nov 2008 11:25:58 -0800 (PST)
Message-ID: <7f180ee5-ba55-4ab5-9552-15602d7ec3e7@n33g2000pri.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 tablespace 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 - 13:25:58 CST

Original text of this message