Tools - MySQL Database Servers - Table Index Properties

You can open the window only from the MySQL Table Properties window. It is used to create new table fields and edit the properties of existing fields. It is made up of three groups of settings: Index Name, Index Type, Belonging Fields.

Index name

It only contains a text field that allows you to enter or change the index.

Index type

Standard index
Optimizes the table search against the specified fields.

PRIMARY KEY index
Primary key, uniquely identifies each record in the table. A field with the AUTO INCREMENT option checked (in the Field Properties window) must belong to this index.

UNIQUE Index
Guarantees the uniqueness of the value of a given field among all in the table - you will not be able to enter two records in the table with the same content of the fields covered by this index.

Index FULLTEXT
Causes indexing of the entire contents of text fields, which speeds up search operations. Note, however, that at the same time it delays data entry into the database, since every word from the contents of this field in the record must be added to the index.

Belonging fields

This group contains a list of fields that you can select to add to the index you are creating or editing. To add a field, select the switch next to its name.