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
databases all ready.
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?
Many thanks.
James
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
