next up previous contents
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