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: ghassan salem <gsalem_at_fr.oracle.com>
Date: Fri, 19 Nov 1999 16:56:44 +0100
Message-ID: <3835733B.CDC4A3C@fr.oracle.com>


No,
There is no way a hint will change the results of a query. Rgds

Buck Turgidson wrote:

> I need to do some tuning of some PeopleSoft Payroll SQL statements, and it
> will probably involve adding some hints to some stored SQL statements. We
> run the instance in RULE.
>
> Could a hint ever change the data returned from a SQL statement? If there
> is a risk of that, then we will obviously need to do some level of
> application testing in parallel to make sure we generate the same paychecks
> with and without the hints.


Received on Fri Nov 19 1999 - 09:56:44 CST

Original text of this message

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