Re: Adding an index to a table

James Riordon wrote: At 15:07 +0800 03/28/2002, Sammy Lau was thought to have said : ?http://www.mysql.com/doc/C/R/CREATE_INDEX.html Granted, I should have looked before I spoke for the first question. 2 - Do I have to do anything special like stop requests to the

Re: Adding an index to a table

At 15:07 +0800 03/28/2002, Sammy Lau was thought to have said : ?http://www.mysql.com/doc/C/R/CREATE_INDEX.html Granted, I should have looked before I spoke for the first question. 2 - Do I have to do anything special like stop requests to the server while I add the index.

Adding an index to a table

Hi, I have a MySQL database that currently is used by about 8000 users. I need to add an index to one of the fields in one of the tables to help speed up a particular query being made to the MySQL database. I am a bit nervous to do so in case I screw up. Mind you I have backed up the

Re: Adding an index to a table

http://www.mysql.com/doc/C/R/CREATE_INDEX.html 1 - What command do I issue to add a simple index to one field in a table. 2 - Do I have to do anything special like stop requests to the server while I add the index. 3 - How safe is this to do? Before posting,