Home >> FAQs/Tutorials >> Oracle Tutorials

Oracle Tutorials - Managing Oracle Table Indexes

By: FYIcenter.com

This is a collection of 14 FAQs for Oracle DBA on creating indexes and managing indexes. The clear answers and sample scripts provided can be used as learning tutorials or interview preparation guides. Topics included in this FAQ are:

  1. What Is an Index?
  2. How To Run SQL Statements through the Web Interface?
  3. How To Create a Table Index?
  4. How To List All Indexes in Your Schema?
  5. What Is an Index Associated with a Constraint?
  6. How To Rename an Index?
  7. How To Drop an Index?
  8. Can You Drop an Index Associated with a Unique or Primary Key Constraint?
  9. What Happens to Indexes If You Drop a Table?
  10. How To Recover a Dropped Index?
  11. What Happens to the Indexes If a Table Is Recovered?
  12. How To Rebuild an Index?
  13. How To See the Table Columns Used in an Index?
  14. How To Create a Single Index for Multiple Columns?

Sample scripts used in this FAQ collection assumes that you are connected to the server with the default user account HR on the default instance XE. All scripts were executed through the Oracle Web interface. See other FAQ collections on how to connect to the server.

It is also assumed that user account HR has the CREATE ANY INDEX privilege needed to manage indexes.

(Continued on next topic...)

Oracle Tutorials:


Other Tutorials/FAQs:


Related Resources:


Selected Jobs: