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 -> Why Index Organized Tables not suituable for OLTP

Why Index Organized Tables not suituable for OLTP

From: <vasarpota_at_my-deja.com>
Date: 2000/07/28
Message-ID: <8lsf8v$pfl$1@nnrp1.deja.com>#1/1 






I know index organized tables are great for DSS applications.  They
save space since index and table are one.  They also improve query
performance. But why are they not suited for DSS applications now that
they can have multiple indexes on IOT?  I keep on reading this but do
not understand why?



Thanks for your help





Sent via Deja.com http://www.deja.com/


Before you buy.
Received on Fri Jul 28 2000 - 00:00:00 CDT












Original text of this message













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