John: OH! D'OH! <expletives deleted>
I missed your paper at IOUG. Probably shouldn't have. This particular query had an index hint in it. We did not try running the query without the hint until the tables were almost all analyzed. Can you shoot me a copy of your paper? Or point me towards a copy on the net? Thanks, Mike -----Original Message----- Sent: Monday, June 24, 2002 5:24 PM To: Multiple recipients of list ORACLE-L Mike, > Shazzam. Back to 2 minutes. Huh? But Optimizer-mode is RULE!! > > How? Why? I look stupid and so does my whole DBA group. > Does anybody have any insights about this behavior? Contrary to common understanding, the Cost based optimizer is 'forced' in certain situations even if the mode is RULE. Examples are: Use of hints other than RULE, Partitioned tables and indexes, Index-organized tables, Reverse key indexes, Function-based indexes, SAMPLE clauses in a SELECT statement, Parallel execution and parallel DML (i.e. presence of DEGREE on Tables/Indexes), etc. Was this the case? This was the focus of my paper at IOUG... John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 The manuals for Oracle are here: http://tahiti.oracle.com The manual for Life is here: http://www.gospelcom.net ** The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).