always uses an index to avoid a sort. It is
possible the FIRST_ROWS is actually the nominally correct
optimizer mode for this bit of the application.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon a new one-day tutorial:
Cost Based Optimisation
(see http://www.jlcomp.demon
…” J
Even still, it’s a delight that we’ll
have him with us in a few weeks.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic, Dec
9–11 Honolulu
- 2003 Hotsos Symposium on
Oracle® System Performance, Feb 9–12 Dallas
- Jonathan Lewis'
Optim
...if only "optimizing" was spelled
correctly... :-)
- Original Message -
From:
Cary
Millsap
To: Multiple recipients of list ORACLE-L
Sent: Thursday, October 31, 2002 1:59
PM
Subject: Jonathan Lewis seminar in
Dallas, 19-2
Announcement
Optimising Oracle: Performance by Design
a 3-day seminar by Jonathan
Lewis
Jonathan Lewis
will conduct his "Optimising Oracle" seminar in the
Dallas/Fort Worth area this November 19-21. "Optimisi
Announcing: Optimizing Oracle -- Performance by Design, by Jonathan Lewis
Jonathan Lewis is planning to hold his Optimizing Oracle seminar in the
Ann Arbor, MI area. This is a three-day, intensive seminar aimed at DBAs and
senior developers and designers.
Jonathan Lewis
