The drop index command removes an index from the database. Its syntax is:
drop index table_name.index_name [, table_name.index_name]...
When you use this command, Adaptive Server removes the specified indexes from the database, reclaiming their storage space.
Only the owner of the index can drop it. drop index permission cannot be transferred to other users. The drop index command cannot be used on any of the system tables in the master database or in the user database.
You might want to drop an index if it is not used for most or all of your queries.
To drop the index phone_ind in the friends_etc table, the command is:
drop index friends_etc.phone_ind
Use sp_post_xpload to check and rebuild indexes after a cross-platform load database where the endian types are different.
