Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Index organized table
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