Re: Keys ignored for larger tables!?
Let's try some index only access..
Please add this KEY and show EXPLAIN again...
ALTER TABLE arinrange
ADD KEY idx_start_end_id (ip_start , ip_end , id );
Please show to every table (instead of DESCRIBE)
mysql>SHOW CREATE TABLE arinrange;
..
with kind regards,
Thomas Wiedmann
Subject
Views
Written By
Posted
2532
April 06, 2011 04:00AM
Re: Keys ignored for larger tables!?
989
April 06, 2011 04:52AM
886
April 06, 2011 05:04AM
865
April 06, 2011 05:10AM
749
April 06, 2011 05:20AM
941
April 06, 2011 05:35AM
845
April 07, 2011 04:23AM
917
April 07, 2011 05:39AM
870
April 07, 2011 05:59AM
814
April 07, 2011 07:08AM
863
April 07, 2011 07:17AM
846
April 07, 2011 01:30PM
1600
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.