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

  • From: Michael Moore <michaeljmoore@xxxxxxxxx>
  • To: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
  • Date: Tue, 31 Jan 2012 11:55:24 -0800

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?
--
//www.freelists.org/webpage/oracle-l


Other related posts: