Have you tried a cross join with a where statement as an alternative?
e.g. select
select i.internalid, c.code
from local.internal i, country.ip c where i.ip between c.startip and c.endip;
Howard Cole
www.selestial.com
Jesse D. wrote:
select i.internalid, c.code
from local.internal i
inner join coun
Hope this is the correct group.
I am running 8.0.1 on XP P4 2.6 1GB for dev work
and the following simple query takes 5+ minutes
to complete. Would like to get this down to <2-3 seconds.
Other RDBMS complete it in <1 second.
select i.internalid, c.code
from local.internal i
inner join country.ip
