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.

Report message to a moderator

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

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jul 12 23:17:36 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.