Create an index

Index creation works just like you'd expect.

SQL> create index home_num_idx
  2  on address_book (id, home_num);

Index created.

SQL>