Re: Do you ever have days where you dont want to think ?

Don't have time to help with the query but following this link may help with the first part:

http://images.google.com/images?hl=en&lr=&q=naked+beach

(you military guys, one tract minds...lol)

Brian P. MacLean
Oracle DBA, OCP8i

                                                                                                                                            
                      "Johnson, Michael "                                                                                                   
                      <Michael.Johnson_at_oln-a        To:       Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>                   
                      fmc.af.mil>                   cc:                                                                                     
                      Sent by:                      Subject:  Do you ever have days where you dont want to think ?                          
                      root_at_fatcity.com                                                                                                      
                                                                                                                                            
                                                                                                                                            
                      05/17/02 02:23 PM                                                                                                     
                      Please respond to                                                                                                     
                      ORACLE-L                                                                                                              
                                                                                                                                            
                                                                                                                                            

I just just wanna go lie on a beach naked on some remote island far far away and not think of anything for a month.

Here is the issue.....

I have a query that looks like this ...

select a.f1, a.f2, a.f3, a.f4 from table1 a where a.f1 not in
( select b.n1 from b );

there is a primary key index on b.n1
there is a concatenated primary key index on a.f1,a.f2,a.f3 there is a non-unique index on a.f1

the query shows that the index is being used on table b, but no indexes are being used on table a.

Mike

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson, Michael
  INET: Michael.Johnson_at_oln-afmc.af.mil

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: 
  INET: Brian_P_MacLean_at_eFunds.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).