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 t
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.
>
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 post
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
