Create Non-Unique index
SQL> SQL> SQL> CREATE TABLE myTable ( 2 myTableID INT PRIMARY KEY NOT NULL, 3 Name VARCHAR(50), 4 PhoneNo VARCHAR(15) DEFAULT 'Unknown Phone'); Table created. SQL> SQL> SQL> CREATE INDEX NameIndex ON myTable (Name); Index created. SQL>