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 Organized Tables

Re: Index Organized Tables

From: Richard Foote <richard.foote_at_bigpond.nospam.com>
Date: Sun, 12 Aug 2007 10:03:15 GMT
Message-ID: <DVAvi.19572$4A1.9671@news-server.bigpond.net.au> 






"Rohit" <rpk.general_at_gmail.com> wrote in message 
news:1186894050.144815.146460_at_q4g2000prc.googlegroups.com...


> When to use Index Organized Tables (IOT) and on what type of tables?

>




Simplistically, when a table is going to be indexed by an index that is 
going to contain all or most of the table columns anyways and the overheads 
associated with any required secondary indexes doesn't put you off.



Cheers



Richard 
Received on Sun Aug 12 2007 - 05:03:15 CDT












Original text of this message













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