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

From: Michael Moore <michaeljmoore_at_gmail.com>
Date: Tue, 31 Jan 2012 11:55:24 -0800
Message-ID: <CACpWLjMRGrhRSFcBers-YG3garGqs_DUjydZU7AexmLYToeAEQ_at_mail.gmail.com>

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-l

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

This message: [ Message body ]
Next message: Taylor, Chris David: "RE: 17Gb table with long column to be replicated."
Previous message: Joel.Patterson_at_crowley.com: "17Gb table with long column to be replicated."
In reply to: Taylor, Chris David: "RE: table in ANSI JOIN *but not* being accessed at all?"
Next in thread: Taylor, Chris David: "RE: table in ANSI JOIN *but not* being accessed at all?"
Reply: Taylor, Chris David: "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?