8.4
How to Manually Add an Index to an Existing Table
- Right-click on the table
- Select ‘Alter Table’
- Click on the ‘Indexes’ tab
- Type the name of the index in the ‘Index Name’ field
- Under ‘Type’ select ‘INDEX’
- Click on the column(s) that you want to index.
- Tab to a new line
This content is provided to you freely by BYU-I Books.
Access it online or download it at https://books.byui.edu/learning_mysql/how_to_manually_add_.