RelationalDBDesign
RedhatLinuxSys Seomining
prev next
  Course navigation
Lesson 1
Index-Organized Tables
 
You can significantly improve the performance of SQL queries with indexes. There may even be times when an index can supply all the information you need in a query. An index-organized table might be able to give you even greater performance benefits than an index alone.
Module objectives
In this module, you will learn how to:
  1. Describe an index-organized table and explain when to use it
  2. Create an index-organized table
  3. Rebuild an index-organized table with the MOVE parameter of the ALTER TABLE command
  4. Create a secondary index on index-organized table
  5. Understand the differences between index-organized and regular tables

Although index-organized tables were introduced in Oracle8, Oracle8i includes significant enhancements to the capabilities of these database objects.
In the next lesson, we will discuss what an index-organized table is.
  Course navigation