Creating and Deleting Indexes by Using SQL DDL

You can designate one or more indexes for a table either at the time the table is built, or after the fact.