Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Performance issue

Re: Performance issue

From: AnySQL (d.c.b.a) <anysql_at_gmail.com>
Date: 10 Sep 2005 09:08:11 -0700
Message-ID: <1126368491.781487.164990@f14g2000cwb.googlegroups.com>


The first may using the JOIN+FILTER to get the result, while the second may using the union to get the result, you need to check the execute plan.

Welcome, Lou Fangxin
http://www.anysql.net/en/
http://www.anysql.net/en/mydul.html Received on Sat Sep 10 2005 - 11:08:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US