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
CC BY-NC-ND International 4.0: This work is released under a CC BY-NC-ND International 4.0 license, which means that you are free to do with it as you please as long as you (1) properly attribute it, (2) do not use it for commercial gain, and (3) do not create derivative works.
End-of-Chapter Survey: How would you rate the overall quality of this chapter?
- Very Low Quality
- Low Quality
- Moderate Quality
- High Quality
- Very High Quality