command line access makes many tasks a heck of a lot easier. It also makes it easier to make a fatal mistake. Do take care when you log in via command line.
The indices are created when the table is created, and populated as the data is inserted, just like when the database is functioning normally.