In article <3890608E.985ABBE2_at_london.virgin.net>, Mike Mountjoy
<michael_at_london.virgin.net> wrote:
> The default is RULES based mode in ORA 7 and CHOOSE in ORA 8
> The database switches to CHOOSE mode when you issue the command
> ANALYZE TABLE <table_name> COMPUTE STATISTICS.
> Regrds,
> Mike
Not exactly true, Mike. It depends on which version of Oracle7. For
7.3.4, the default is CHOOSE. However, both 7.3.4 and 8 will use RULE
if you execute a query on a table that does not have statistics. The
database will not automatically switch to CHOOSE if the optimizer_mode
is either set to RULE or has not been set (defaults to RULE) in an
earlier version than 7.3.4, no matter how many times you analyze the
tables.
- Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!
Received on Thu Jan 27 2000 - 10:05:37 CST
