I found out how to add a primary key index
using ALTER TABLE (looks like the only way
to add a PK index). Can I use ALTER TABLE
to add a regular index? What is the syntax?