Next: Query the table Up: Oracle Basics Previous: Add data to a Contents

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>

2005-02-10