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 -> Can Perf. Hints Change Result Set

Can Perf. Hints Change Result Set

From: Buck Turgidson <jcman_at_worldnet.att.net>
Date: Thu, 18 Nov 1999 16:08:09 -0800
Message-ID: <811put$9ek$1@bgtnsc02.worldnet.att.net> 





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 Thu Nov 18 1999 - 18:08:09 CST












Original text of this message













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