|
INDEX
It is a schema object.Used to speed up the retrieval of rows by using a pointer.
Two types ::
1. Unique - Created automaticlly by the oracle server
2. Nonunique - Created by the user
Syntax ::
CREATE INDEX <INDEXNAME>
ON <TABLENAME> (COLUMNS);
Example ::
CREATE INDEX CUST_IDX
ON CUSTOMER (CUST_DEPTID) ;
|
|
