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.
[EMAIL PROTECTED]
618-622-4145
-----Original Message-----
From: Mark Richard [SMTP:[EMAIL PROTECTED]
<<< 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 >>>