RE: IOT Vs Normal Tables

Worst case with the one I have, I could reproduce the data (the primary key data comes from an outside source, I have the CDs containing that data) and I could, by reading another table, set the used/unused flag.

I'd hate having to do it, but I could. Which is why I have good backups :)

>From: Kimberly Smith <kimberly.smith_at_gmd.fujitsu.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: Thu, 14 Dec 2000 10:46:56 -0800
>
>Oracle8's export was not updated to be able to export any of the new
>features (ie IOT's). Gets me every time, even though I know its there.
>As a result I have refrained from using them again and if I get a chance
>I am changing the two that are there). I am not sure if Oracle8i has
>an updated export or not. I would check but today I am being lazy.
>
>-----Original Message-----
>Sent: Thursday, December 14, 2000 9:31 AM
>To: Multiple recipients of list ORACLE-L
>
>
>
>Any other known complications?
>
>Alex Hillman
>
>-----Original Message-----
><mailto:carmichr_at_hotmail.com> ]
>Sent: Thursday, December 14, 2000 10:51 AM
>To: Multiple recipients of list ORACLE-L
>
>
>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
><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
><http://explorer.msn.com>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
><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
>also send the HELP command for other information (like subscribing).
>