# CTE Resource Center - Verso - Database Design and Management (Oracle) Task 1955277944

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Describe the index.

Definition

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.