Home » SQL & PL/SQL » SQL & PL/SQL » IOT tables.
IOT tables. [message #300919] Mon, 18 February 2008 12:59 Go to next message
arksjd
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.

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

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


Current Time: Fri Dec 02 18:23:51 CST 2016

Total time taken to generate the page: 0.47436 seconds