| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: HP-UX 11.0/8.1.6.2.0/Optimizer
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
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: 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.com -- Author: Vergara, Michael (TEM) INET: mvergara_at_guidant.com 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: 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 Mon Jun 24 2002 - 19:53:28 CDT
 |
 |