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
