Re: OPTIMIZER_HINT, FIRST_ROWS, and MAX

athaung_at_gmail.com wrote:
> The Oracle version exhibiting the problem is 8.1.7.0.0.
> The problem does NOT show up in 9.2.0.1.0.

8.1.7.0.0? This is desupported paleolithic software to which you have not applied a single patch in a decade. And now, it appears, you are doing the same thing with 9.2.

Lesson 1 ... purchase a support contract and patch regularly for reasons of security, stability, performance, and scalability. Oracle is serious software, not a microwave oven, you must pay attention if you want it to work properly.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org