RE: CBO not using the index even though it is faster when hinted ....

Oh heck, of course!
Why didn't I think of that? BAHH!
Gotta quick staying up so bloody late!

RF

-----Original Message-----
Lewis
Sent: Friday, January 24, 2003 2:49 AM
To: Multiple recipients of list ORACLE-L hinted ....

Are any of the columns in the index declared to be NOT NULL - if not, then the hint is invalid because obeying it could produce the wrong answer.

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Coming soon a new one-day tutorial:
Cost Based Optimisation
(see http://www.jlcomp.demon.co.uk/tutorial.html )

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____England______January 21/23
____USA_(CA, TX)_August

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

-----Original Message-----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: 24 January 2003 03:19
....

>Anyone have any problems with the CBO not using
>a index when you know it is faster by forcing a
>hint ?
>
>I have set the following ...
>
>Solaris
>Oracle Version 8.1.7.4
>
>block size = 8
>DB_FILE_MULTIBLOCK_READ_COUNT = 8
>mode = Choose
>
>also using Tim Gormans 90 and 50 values for the other optimizer
parms.
>
>Select col1, col2, col3, blah1, blah2 from table order by col1, col2,
col3;
>
>
>Concatenate index on col1, col2, col3.
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  INET: jonathan_at_jlcomp.demon.co.uk

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Robert Freeman
  INET: robertgfreeman_at_yahoo.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).