RE: table in ANSI JOIN but not being accessed at all?

From: Taylor, Chris David <ChrisDavid.Taylor_at_ingrambarge.com>
Date: Tue, 31 Jan 2012 13:24:17 -0600
Message-ID: <C5533BD628A9524496D63801704AE56D6ADD161B89_at_SPOBMEXC14.adprod.directory>

Yes, CO.CUSTOMER_ID references CU.CUSTOMER_ID.

I'm curious what you have in mind?

Thanks,

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 12:46 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?

Does cu.customer_id = co.customer_id have a foreign key constraint?

Mike

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jan 31 2012 - 13:24:17 CST

This message: [ Message body ]
Next message: Joel.Patterson_at_crowley.com: "17Gb table with long column to be replicated."
Previous message: Greg Rahn: "Re: Killer SQL and PGA"
In reply to: Michael Moore: "Re: table in ANSI JOIN *but not* being accessed at all?"
Next in thread: Michael Moore: "Re: table in ANSI JOIN *but not* being accessed at all?"
Reply: Michael Moore: "Re: table in ANSI JOIN *but not* being accessed at all?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

RE: table in ANSI JOIN *but not* being accessed at all?

RE: table in ANSI JOIN but not being accessed at all?