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: Large Index organized tables: just a marketing feature ?! (for ex perts)

Re: Large Index organized tables: just a marketing feature ?! (for ex perts)

From: Andras Kovacs <andkovacs_at_yahoo.com>
Date: 30 Jul 2003 10:06:22 -0700
Message-ID: <412ebb69.0307300906.1899bbd@posting.google.com> 





Well, this is still true in version 8 and 9.



I think Oracle handles IOT as a heap table with Index. Or this
behaviour is wrong because the table part doens't exist. For IOTs
Oracle should have a distinct behaviour. It is deep in the design.



I thinks IOTs are not widely used because of this major performance
problem.


I didn't find many references to IOTs
Received on Wed Jul 30 2003 - 12:06:22 CDT












Original text of this message













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