|< < 27 > >|

Indexes

2) Use an index

To speed things up, add an index to the field(s) being restricted.

  • An index is associated with a table.

  • One or more of the table's columns form the index's key.

  • In spite of the terminology (key), uniqueness is not implied.

  • Uniqueness is an option.

|< < 27 > >|