Index
Index:
Indexes are used to speed up searching. Primary keys are automatically indexed, but you can add indexes to other fields to allow them to be easily searchable.
Syntax:
INDEX Index_name(field)
Example:
INDEX inx1(keyword);
This example provides an index called ‘inx1′ for a field called ‘keyword’.
