Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle position on hints
Hi,
We recently upgraded from 7.3.4 to 8.7 (management plans on getting to that Y2K problem shortly ;-) We had an SQL statement that really needed a hint in 7.3.4. After upgrading to 8.7, I removed the hint and it runs much faster without it. I spend some of my spare time testing SQL with hints removed now.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
jerome.whittle_at_scott.af.mil
618-622-4145
> -----Original Message-----
> From: Mark Richard [SMTP:mrichard_at_transurban.com.au]
>
<<< snip >>>
> 1) You are limiting functionality when the database is upgraded - I have
> seen several examples where Oracle went from 7 to 8 and noone looks at
> every SQL statement to reevaluate the validity of every hint.
>
<<< snip >>>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Whittle Jerome Contr NCI INET: Jerome.Whittle_at_scott.af.mil Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Mar 11 2003 - 07:33:57 CST