Re: Indexed Organized Tables

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Thu, 13 Jan 2005 22:39:23 -0800
Message-ID: <41e76911$1_1@127.0.0.1>

Mladen Gogala wrote:

> On Mon, 10 Jan 2005 12:17:52 -0600, Florian wrote:
>
>

>>Sometimes multiple records are written at the same time (same second), 
>>so it is impossible for us to create a primary key on the x_timestamp 
>>field, since we might loose records that.

>
>
> Oracle has the data type called TIMESTAMP, which actually goes down to
> nanosecond. Using that for a primary key is a bad idea.
>
>

>>Yet, we don't want to add any of the other fields to the timestamp since 
>>that doesn't seem to be logical. We tried it and the performance wasn't 
>>that great it seems.

>
>
>
> You can always have a generated primary key, by using sequences.
>
>

>>Is there no way to create an indexed organized table without using a 
>>primary key??

>
>
> Creating tables without primary keys is illegal in Georgia, Tennessee,
> South Carolina, Kentucky and Mississippi. In Wyoming, Texas, Florida and
> Alabama you can actually be executed for creating tables without primary
> key.

Heck in Texas they seem to be willing to execute you just for not being the flavour of the month.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Fri Jan 14 2005 - 00:39:23 CST