Re: Keys ignored for larger tables!?
Please check these two samples..
explain
select start.id
from ( select id from arinrange where ip_start<=1582783255 ) start
join ( select id from arinrange where ip_end>=1582783255 ) end
on start.id = end.id;
explain select id from arinrange where 1582783255 between ip_start and ip_end ;
with kind regards,
Thomas
Subject
Views
Written By
Posted
2506
April 06, 2011 04:00AM
982
April 06, 2011 04:52AM
876
April 06, 2011 05:04AM
854
April 06, 2011 05:10AM
746
April 06, 2011 05:20AM
933
April 06, 2011 05:35AM
839
April 07, 2011 04:23AM
Re: Keys ignored for larger tables!?
909
April 07, 2011 05:39AM
859
April 07, 2011 05:59AM
802
April 07, 2011 07:08AM
862
April 07, 2011 07:17AM
839
April 07, 2011 01:30PM
1594
April 08, 2011 08:20PM
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.