SQL Drop Index

The drop index statement removes the index from the database. It requires the name of the index as specified in the eXtremeSQL Metatable. For example:

 
    drop index MyIndex;
 

Once an index is dropped any select statement accessing a column that had been included in the index may be significantly slower. (Please see SQL Optimizer for details about performance optimization using indexes.)