Re: Can Perf. Hints Change Result Set

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sat, 20 Nov 1999 00:33:16 +0800
Message-ID: <38357BCC.6A47@yahoo.com>

Jonathan Lewis wrote:
>
> Apart from the bugs ;)
>
> My latest is one in 8.1.5 where
>
> select /*+ parallel (t,4) */
>
> returns no rows, but
>
> select /*+ noparallel (t) */
>
> returns data.
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> ghassan salem wrote in message <3835733B.CDC4A3C_at_fr.oracle.com>...
> >No,
> >There is no way a hint will change the results of a query.
> >Rgds
> >
> >Buck Turgidson wrote:

And an ol' favourite from 7.3.3 where index_desc gave rows that didn't even meet the original where clause criteria... --

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Fri Nov 19 1999 - 10:33:16 CST