Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can Perf. Hints Change Result Set

Re: Can Perf. Hints Change Result Set

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 19 Nov 1999 20:11:29 -0000
Message-ID: <943043220.3035.0.nnrp-14.9e984b29@news.demon.co.uk>

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:
Received on Fri Nov 19 1999 - 14:11:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US