What is an Index Organized Table?

1
What is an Index Organized Table?

• An index-organized table keeps its information
  categorized according to the primary key line
  principles for the table.
• An index-organized table allows you to shop its
  whole information in a catalog

2
index-organized table

• An index-organized table has a storage space
  organization that is a version of a main B-tree.
• Unlike an ordinary (heap-organized) table whose
  information is saved as an unordered collection
  (heap), information for an index-organized table
  is held in a B-tree catalog framework in a main
  key sorted manner. Each leaf block in the catalog
  framework stores both the key and nonkey content.

3
Index-organized table provides the following
benefits

• Fast random accessibility on the main key because
  an index-only scan is sufficient.
• Fast range accessibility on the main key because
  the series are grouped in main key purchase.
• Lower storage space requirements because
  duplication of main keys is avoided

4
Key compression

• Overflow storage space space and particular line
  placement.
• Secondary indices, including bitmap indices.
• Index-organized platforms are ideal for OLTP
  programs, which need quick main key accessibility
  and high availability.

5

• Thank You