Re: With Clause
From: William Robertson <williamr2019_at_googlemail.com>
Date: Sat, 8 Nov 2008 02:13:19 -0800 (PST)
Message-ID: <2654c635-5c37-4055-85c2-7c97875487ac@s9g2000prg.googlegroups.com>
Date: Sat, 8 Nov 2008 02:13:19 -0800 (PST)
Message-ID: <2654c635-5c37-4055-85c2-7c97875487ac@s9g2000prg.googlegroups.com>
On Nov 6, 8:51 am, raja <dextersu..._at_gmail.com> wrote:
> Should we use /*+ MATERIALIZE */ ( materialize hint ) even in 10g ?
Only if you need the set materialised. If you don't it's just extra I/ O. Received on Sat Nov 08 2008 - 04:13:19 CST