An index can be created in a table to find data more quickly and efficiently. The users cannot see the indexes, they are just used to speed up searches/queries.
CREATE INDEX PIndex ON Persons (Name)
The DROP INDEX statement is used to delete an index in a table.
DROP INDEX table_name.index_name