Re: rm RULE based optimizer != GOOD IDEA

From: Martic Zoran <zoran_martic_at_yahoo.com>
Date: Fri, 22 Apr 2005 06:49:20 -0700 (PDT)
Message-ID: <20050422134920.82691.qmail@web52607.mail.yahoo.com>

Anybody knows why HASH_AJ and HASH_SJ are deprecetad in 10g?

Oracle introduced much more in 10g then what is deprecated.
You have a lots of NO_ hints to not use something like NO_USE_NL. Of course all these hints are evil in according to Tom Kyte and should not be used. But of course it is easier to spend many days fighting statistics.

Are there any tool on the market to recommend what statistics should be for the certain SQL :)

• Wolfgang Breitling <breitliw_at_centrexcc.com> wrote:
  > It has already done so. The selectivity hint is gone
  > in 10g. I would
  > have preferred it over the cardinality hint - at
  > least at times.
  

  ---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Apr 22 2005 - 09:53:31 CDT