Re: How to speed up query of indexed column with 5M rows?
Posted by:
ryan zheng
Date: October 10, 2006 12:23AM
Sorry, Larry Kagan I can not do a test to add KEY `flow_nameindex` (name(15)). Because mysql do ALTER TABLE by creating a new table and copying your data into it. It will take a very very long time for my such a large data. I had waited for a hour to do a drop index, but aborted finally for no seeing any result and rest time.
Subject
Views
Written By
Posted
24641
October 09, 2006 06:34AM
9057
October 09, 2006 08:11AM
Re: How to speed up query of indexed column with 5M rows?
7629
October 10, 2006 12:23AM
6907
October 10, 2006 08:45AM
6621
October 12, 2006 07:57PM
6580
October 09, 2006 09:40AM
6218
October 09, 2006 08:39PM
5204
October 09, 2006 07:54PM
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.