Re: Questions on hard coded vs bind variable performance

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 6 Apr 2005 17:43:40 +0000 (UTC)
Message-ID: <d3174c$en1$1@hercules.btinternet.com>

Original Message ----- From: "Joachim Zobel" <jz-2004_at_heute-morgen.de>
:
: By the way, do versions above 8.1.7 have a hint to tell the optimizer the
: selectivity of a condition? Would be something to look forward for.
:

9i has both a cardinality() and a selectivity() hint, which can be used for single tables or a list of tables. Unfortunately the selectivity() hint seems to have broken in 10g.

Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html Public Appearances - schedule updated April 5th 2005 Received on Wed Apr 06 2005 - 12:43:40 CDT