If you want to add an index for one table you can use the ALTER TABLE or CREATE INDEX these 2 satements the ALTER TABLE is the most flexible. To add an index to a table, type ADD in front of your statement, as if we have a table called contactPerson with result fields.
Read more