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: Index organised table

Re: Index organised table

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 04 Dec 2005 12:04:12 -0800
Message-ID: <1133726635.508962@jetspin.drizzle.com>


Mark A wrote:

> But you also need to consider the amount of inserts and deletes performed on
> the table (and updates of the clustering column). If the table has
> relatively few inserts or deletes, then the extra performance hit of using
> the IOT will not be noticeable, and you will save space over the b-tree
> clustered index.

clustering columns? b-tree clustered index?

What product are you writing about? And why are you writing about it in c.d.o.server?

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Sun Dec 04 2005 - 14:04:12 CST

Original text of this message

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