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
24520
October 09, 2006 06:34AM
9020
October 09, 2006 08:11AM
Re: How to speed up query of indexed column with 5M rows?
7571
October 10, 2006 12:23AM
6866
October 10, 2006 08:45AM
6578
October 12, 2006 07:57PM
6543
October 09, 2006 09:40AM
6174
October 09, 2006 08:39PM
5153
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.