Re: My last comments... I may be thinking about group by's, not order by's... I'm confusing myself... :-)
RF -----Original Message----- Michael Sent: Thursday, January 23, 2003 8:29 PM To: Multiple recipients of list ORACLE-L .... 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: Johnson, Michael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
