Lesson 1
Using index-organized tables
So far in this course, you have learned how to use both partitioning and clusters to optimize the physical retrieval of data in
your Oracle database from disk.
Index-organized tables are a feature introduced with Oracle8, and these database structures can to improve performance when used with
appropriate types of data.
In this module, you will not only learn about index-organized tables, but you learn to:
In the next lesson, you will learn how index-organized tables differ from normal tables.
In this module, you will not only learn about index-organized tables, but you learn to:
- Explain how index-organized tables differ from normal tables
- Know when to use an index-organized table
- Create an index-organized table
- Create secondary indexes on an index-organized table
- Handle large rows in an index-organized table
- Delete and modify index-organized tables
- Reorganize an index-organized table
In the next lesson, you will learn how index-organized tables differ from normal tables.