Is this a good case for an IOT?

From: dean <deanbrown3d_at_yahoo.com>
Date: Wed, 01 Aug 2007 15:32:31 -0700
Message-ID: <1186007551.014874.110190@k79g2000hse.googlegroups.com>

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 Received on Wed Aug 01 2007 - 17:32:31 CDT