400 Chapter10
SQL Statements A - D
DROP INDEX
Example
DROP INDEX PartsOrderedIndex
FROM PurchDB.OrderItems
Alternatively:
DROP INDEX PurchDB.PartsOrderedIndex
If you discover that an index does not improve the speed of data access, you can delete it. If
applications change, you can redeļ¬ne the index.
