Should you name indexes while doing ALTER TABLE ?
Posted by peter
MySQL Server does not require you to specify name of the index if you’re running ALTER TABLE statement - it is optional. Though what might be good practical reasons to specify the key name or omit ?
Things what you should be looking at is how MySQL names indexes automatically as well as what maintaining the indexes.
[read more...]
del.icio.us
digg