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
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.
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
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,