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.