RE: table in ANSI JOIN *but not* being accessed at all?
Date: Tue, 31 Jan 2012 13:59:45 -0600
Message-ID: <C5533BD628A9524496D63801704AE56D6ADD161BAA_at_SPOBMEXC14.adprod.directory>
I was mistaken. The FK is on PS_CUST_ID on CU instead of CUSTOMER_ID
So the FK is CO.CUSTOMER_ID references CUSTOMER.PS_CUST_ID.
The CUSTOMER_ID in CU is not REFERENCED.
Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
"Quality is never an accident; it is always the result of intelligent effort." -- John Ruskin (English Writer 1819-1900)
CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium.
-----Original Message-----
From: Michael Moore [mailto:michaeljmoore_at_gmail.com]
Sent: Tuesday, January 31, 2012 1:55 PM
To: Taylor, Chris David
Cc: Phillip Jones; oracle-l_at_freelists.org
Subject: Re: table in ANSI JOIN *but not* being accessed at all?
There is no reason to do the join because the RI tells us that the CU row HAS to be there. You are not pulling any data from CU and not filtering on data from CU. Right?
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 31 2012 - 13:59:45 CST