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 Table -- ORA-25182

Re: Index Organized Table -- ORA-25182

From: Joerg Lanzinger <joerg_at_lanzinger.de>
Date: Mon, 25 Oct 1999 13:45:11 +0200
Message-ID: <381442C7.31086C4A@lanzinger.de>


Hello Chris,

I once ask Oracle Germany what to do when working with IOTs. Simple answer: Upgrade to Oracle8i (i.e. 8.1.5).

A unvaluable advantage of 8i is that IOTs are now known to the optimizer and it will no longer try to use a FFS for each query.

Hope that helps,
  Joerg Received on Mon Oct 25 1999 - 06:45:11 CDT

Original text of this message

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