RULE vs CHOOSE
From: Business Information Services <email_at_bisinfo.com.au>
Date: 1997/08/11
Message-ID: <MPG.e590c7723a1d3f1989681_at_nsw-newshost.tpgi.com.au>#1/1
Date: 1997/08/11
Message-ID: <MPG.e590c7723a1d3f1989681_at_nsw-newshost.tpgi.com.au>#1/1
Hi,
[Quoted] [Quoted] Probably another stupid question ... :-)
[Quoted] If the database tables are never analysed is there any point in having the OPTIMISER set to CHOOSE (the default) and in fact would it slow things down? I mean I don't know what happens in the bowels of Oracle but [Quoted] I'd say it would probably spend some superfluous time searching for table [Quoted] statistics before using rules.
[Quoted] Any thoughts appreciated.
Rowan McCammon. Received on Mon Aug 11 1997 - 00:00:00 CEST