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 -> Re: compressed index and partition table?

Re: compressed index and partition table?

From: Reid Lai <reidlai_at_netvigator.com>
Date: Sat, 01 Sep 2001 01:05:11 +0800
Message-ID: <3B8FC3C6.E9E4B21@netvigator.com> 





Then I recommend partition with a static key as partition key with ROW MOVEMENT
option for exceptional case rather than choosing IOT if it is OLTP table.



Kate Lin wrote:



> Hi,

>

> this table has 36 million rows, we did not use IOT and our application will

> not update primary key frequently.

>

> thanks a lot

Received on Fri Aug 31 2001 - 12:05:11 CDT












Original text of this message













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