Indexes

Page 563


Viewing indexes syntax:

SELECT object_name
FROM user_objects
WHERE object_type = 'INDEX';

Create an index syntax:

CREATE [UNIQUE|BITMAPPED] INDEX indexname
  ON tablename
  (column|col_expression [,column|col_expression]...)
  [PCTFREE integer]
  [TABLESPACE tablespacename|DEFAULT]
  [STORAGE ([INITIAL integer [K|M]]
            [NEXT integer [K|M]])]
  [ONLINE]

Composite Indexes

Building indexes based on multiple columns.

Back