MySQL: Add index to an active table

My _sitecustomers table has around 67,000 records and after optimizing the site's search I decided I should have indexed 1 or 2 more columns to speed up the query. Is there a way to index an already active table with this many records?

Answers


67k is not a real big number of records. A simple ALTER TABLE statement will work:

ALTER TABLE `_sitecustomers`
    ADD INDEX `col1` (`col1`),
    ADD INDEX `col2` (`col2`);

Need Your Help

image overlaps text view in android activity

android android-textview

Hi i am new to android and i have the following problem(see image).

Python: add a new mimetype

python python-2.7 python-3.x mime-types mime

How can I add a new mimetype using the add_type() function in the mimetypes package? Do I need to do something with the python file system? If I try something like: add_type('text/new', 'new') no...

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.