Re: NO_EXPAND Hint

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 10 Dec 1999 18:18:06 -0000
Message-ID: <944850008.5217.0.nnrp-14.9e984b29@news.demon.co.uk>

That's pretty clever - how did you find it ?

When I put a search for NO_EXPAND to metalink 2.0 this one didn't show up.

When I did a search on 35934.1 I got something completely different.

A couple of further 'seek and ye shall find' notes includes this one: (Note: 62153.1 on avoiding excess memory usage in parsing - how to avoid..)

Use NO_EXPAND hint. This will NOT use an index with Oracle7 but can in Oracle8

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

ykhogaly wrote in message <82pvqq$26m$1_at_inet16.us.oracle.com>...
>Hi,
>
>The Phrase "appears to be not documented until 8i" is NOT True. Attached is
>Note which clearly establishes this fact.
>
> SQL Statement Hints - A Summary (7.3) See [NOTE:35934.1] for CBO
issues.
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
Received on Fri Dec 10 1999 - 12:18:06 CST