Creating an Index

• Syntax

  CREATE [UNIQUE] INDEX index_name
  
  ON table_name (column_name)

• Example

  create index auind
  
  on authors (au_id)

Previous slide

Next slide

Back to first slide

View graphic version