MySQL Forums
Forum List  »  Performance

Re: Keys ignored for larger tables!?
Posted by: Thomas Wiedmann
Date: April 07, 2011 05:39AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
2506
April 06, 2011 04:00AM
Re: Keys ignored for larger tables!?
909
April 07, 2011 05:39AM
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.