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

Home -> Community -> Usenet -> c.d.o.server -> Index organized table

Index organized table

From: lve <lve3162_at_yahoo.com>
Date: 15 May 2002 07:20:42 -0700
Message-ID: <93096888.0205150620.68aa6cf7@posting.google.com>


I have a table in an OLTP database which is subject to very frequent inserts. The table has a sequential number column which is the primary key of the tables. Rows are almost never deleted from this tablethey  are, of course, archived every couple of months.

Is this table a good candidate for INDEX ORGANIZED TABLE? I am using oracle 8.1.7

thanks

lve Received on Wed May 15 2002 - 09:20:42 CDT

Original text of this message

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