Re: subquery vs. join?
You might be able to phrase an easier question.
create temporary table t
select SQL_BIG_RESULT
login_ip,
count(*) as freq
from log
group by login_ip;
select
speed_type,
sum(freq) as freq
from t a , ip_region b
where a.login_ip between b.start_ip and b.end_ip
group by speed_type;
Subject
Views
Written By
Posted
20919
December 03, 2004 02:52AM
7327
December 05, 2004 03:03AM
6153
December 05, 2004 07:52PM
6410
January 20, 2005 03:48AM
5528
January 20, 2005 06:52AM
4860
January 21, 2005 11:43PM
5054
January 21, 2005 11:38PM
Re: subquery vs. join?
4078
January 20, 2005 04:41PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.