I have a vendor application that is running slow. I looked at the code
through a product called SQLab and found that most of the code has a
ROW_ID hint coded in it. My understanding is that this hint will
prevent the code from using indexes even though the tables and indexes
are analyzed. I modified the Oracle startup parameters to use optimizer
mode = FIRST_ROWS which favors indexes. Now when I run the application
the response time is much better. I am thinking this may be a good fix
but is there any kind of program logic I could be screwing up by using
FIRST_ROWS?
Thanks!
Ron Smith
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Smith, Ron L.
INET: rlsmith_at_kmg.com
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 Aug 26 2003 - 16:04:27 CDT
