Snippet Name: INDEXES: DROP index Description: Dropping an index from a table. Also see:» INDEXES: View table indexes » INDEXES: Analyze Index » INDEXES: Block Dump » INDEXES: Rebuild Reverse » INDEXES: » INDEXES: ENABLE (function-based index) » INDEXES: DISABLE (function-based index) » INDEXES: Alter Index Parallel » INDEXES: Alter Index Deallocate Unused » INDEXES: Alter Index Allocate Extent » INDEXES: Virtual / NoSegment » INDEXES: Reverse Key Indexes » INDEXES: Bitmap Join Indexes » INDEXES: Bitmap Indexes » INDEXES: Unique indexes » INDEXES: Parallel Index » INDEXES: Compute Statistics » INDEXES: SORT and NOSORT » INDEXES: Function-Based Index » INDEXES: Alter index » INDEXES: Single Column Non-unique » INDEXES: Index Usage Notes » Compressed Indexes » Create INDEX Comment: (none) Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 11th, 2009
Description: Dropping an index from a table.
Also see:» INDEXES: View table indexes » INDEXES: Analyze Index » INDEXES: Block Dump » INDEXES: Rebuild Reverse » INDEXES: » INDEXES: ENABLE (function-based index) » INDEXES: DISABLE (function-based index) » INDEXES: Alter Index Parallel » INDEXES: Alter Index Deallocate Unused » INDEXES: Alter Index Allocate Extent » INDEXES: Virtual / NoSegment » INDEXES: Reverse Key Indexes » INDEXES: Bitmap Join Indexes » INDEXES: Bitmap Indexes » INDEXES: Unique indexes » INDEXES: Parallel Index » INDEXES: Compute Statistics » INDEXES: SORT and NOSORT » INDEXES: Function-Based Index » INDEXES: Alter index » INDEXES: Single Column Non-unique » INDEXES: Index Usage Notes » Compressed Indexes » Create INDEX
DROP INDEX index_name; -- for example: DROP INDEX supplier_metrics;