RE: Using miss-spelled hint changes explain plan ...

Me wonders if the optimizer ignores all the hints after the first misspelled/malformed one. What happens if you change the order of the hints:

FROM (SELECT /*+ INDEX(C PF_EVENTS_N2) INDEX(G PF_ACCOUNTS_U2) ORDERED driving_site(a) */

and

FROM (SELECT /*+ INDEX(C PF_EVENTS_N2) INDEX(G PF_ACCOUNTS_U2) ORDERED diving_site(a) */

At 09:49 AM 11/20/2003, you wrote:
>Thanks Rob,
>
>me thought the very same until I ran it through ...
>here is my script file ...
>[snip]

> FROM (SELECT /*+ driving_site(a) INDEX(C PF_EVENTS_N2) INDEX(G
> PF_ACCOUNTS_U2) ORDERED */
[snip]

> FROM (SELECT /*+ diving_site(a) INDEX(C PF_EVENTS_N2) INDEX(G
> PF_ACCOUNTS_U2) ORDERED */
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com

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