Title: Describe the index.
Course: Database Design and Management (Oracle) (10052) > Section: Creating Additional Database Objects

Description should include that an index

- is a schema object used to speed up the retrieval of rows by using a pointer
- requires the following syntax:

CREATE INDEX name
ON [table name] (column)

- should be maintained at regularly scheduled periods to ensure efficient operation.