From the course: Oracle Database 19c: Basic SQL
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Dropping indexes
- Disk space is not unlimited, so if you don't need an index any longer, for example identified by an index monitoring report, you can drop it. You can drop it permanently, or you can retrieve it from the database's recycle bin, if the database is configured with a recycle bin in the correct settings. In this video, I'll go over how a index gets dropped and recovered, and the kind of areas you might see where an index is not droppable for one of several reasons. Here's the syntax of the drop index command. You specify the name of the index and optionally the name of the index's schema, if it's not in your schema. If you want DML to occur on the table containing the index while the index is being dropped, use the online keyword. Dropping an index is generally fast and easy. In the first example, I'm dropping the index LOC_ID_BPK on the table locations, while the table remains online and available to users. In the second example, however, I get an error message. If an index is…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.