Home » SQL & PL/SQL » SQL & PL/SQL » IOT tables.
IOT tables. [message #300919] Mon, 18 February 2008 12:59 Go to next message
Messages: 13
Registered: November 2007
Junior Member
I wanted to create a table that will store 3 million records. The Primary key is on contract code and transaction date.

Should I create a normal table or index organised tables. What are the advanteages and disa advanteges of creating a IOT.

Re: IOT tables. [message #300920 is a reply to message #300919] Mon, 18 February 2008 13:04 Go to previous message
Michel Cadot
Messages: 65090
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Concepts
Chapter 5 Schema Objects
Section Overview of Index-Organized Tables

Previous Topic: with <dummy_name> as ..
Next Topic: Function Access Problem
Goto Forum:

Current Time: Thu Jul 27 21:46:43 CDT 2017

Total time taken to generate the page: 0.12000 seconds