Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Is this a good case for an IOT?

Re: Is this a good case for an IOT?

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 01 Aug 2007 18:57:50 -0700
Message-ID: <1186019868.480372@bubbleator.drizzle.com>


dean wrote:
> 9.2i, 10g, Windows platforms.
>
> Hello all,
>
> We have a table USER_PREFERENCE, which gets updated frequently by
> various users, and appears to be badly fragmented (takes relatively
> large per-record timespan to load into memory, compared to other
> tables). It has 5 fields:
>
> Name Null? Type
> ----------------------------- -------- --------------------
> USER_I NOT NULL VARCHAR2(30)
> FORM_I NOT NULL VARCHAR2(100)
> CATEGORY_I NOT NULL VARCHAR2(100)
> KEY_I NOT NULL VARCHAR2(100)
> VALUE_X VARCHAR2(2000)
>
> The primary key is on the first 4 fields. There are no NULL values for
> the last field, VALUE_X.
>
> Is this a good candidate for an index organized table? The hope being
> that this would then maintain itself over time and solve the loading
> issue.
>
> Thanks for any tips!
>
> DeanB

Possibly but how is it accessed and on what basis do you make the statement "appears to be badly fragmented," what does that mean, and what has that got to do with anything? Extents are never laid down on disk contiguously ... not even in an IOT.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Aug 01 2007 - 20:57:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US