RE: IOT Vs Normal Tables

Another complication associated with IOT is a bug which prevents moving the segment to different tablespace. While the syntax exists to perform such task, the actual operation doesn't produce desired result or at least not for me. As per Oracle's response to TAR:

<bug:1245424>
TABLESPACE OF THE OVERFLOW SEGMENT WRONG AFTER IOT MOVE This was filed in 8.2 and fixed in 8.2. There is no reference to this in 8.1.6.
I could not find any other bugs that seem to apply here. I think that we will need
to test this. Unfortunately, Development has not unpublished that bug as of yet.
It is fixed in 8.2. The request for inclusion in the next 8.1.7 patchset (which will be 8.1.7.2) has not been rejected so it will probably become available in that release.

Gary

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Rachel
> Carmichael
> Sent: Thursday, December 14, 2000 10:51 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: IOT Vs Normal Tables
>
>
> IOTs can complicate your life (try looking for the object name, I freaked
> when I didn't see the table name)...
>
> BUT.. I have a table with 2 columns -- the first is 12 characters and the
> primary key. The second is one character -- used or unused. Made
> no sense to
> me to create a table and an index when I would ALWAYS be accessing both
> columns...... and I got to play with an IOT as well :)
>
> Rachel
>
>
> >From: jared still <jkstill_at_teleport.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: Re: IOT Vs Normal Tables
> >Date: Wed, 13 Dec 2000 20:35:31 -0800
> >
> >On Wed, 13 Dec 2000, Sanjay Kumar wrote:
> >
> > > Hi,
> > >
> > > Can anyone tell me how to see the performance differences of
> using IOTs
> >over the normal tables.
> > >
> > > Sanjay
> > >
> >
> >I don't think you will see any performance increase
> >from an IOT.
> >
> >You can get the same performance if your query can
> >be satisfied by an index without reading the table.
> >i.e. the index has all the columns to satisfy the query.
> >
> >IOT's just save space and complicate your life. :)
> >
> >Jared Still
> >Certified Oracle DBA and Part Time Perl Evangelist ;)
> >jkstill_at_teleport.com
> >jared_still_at_enron.net
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: jared still
> > INET: jkstill_at_teleport.com
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
> __________________________________________________________________
> ___________________
> Get more from the Web. FREE MSN Explorer download :
http://explorer.msn.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
  INET: carmichr_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may