Message-Id: <10710.124587@fatcity.com> From: Alex Hillman Date: Thu, 14 Dec 2000 12:21:39 -0500 Subject: RE: IOT Vs Normal Tables This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C065F2.519AA4A0 Content-Type: text/plain; charset="iso-8859-1" Any other known complications? Alex Hillman -----Original Message----- From: Rachel Carmichael [mailto:carmichr@hotmail.com] 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 >Reply-To: ORACLE-L@fatcity.com >To: Multiple recipients of list ORACLE-L >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@teleport.com >jared_still@enron.net > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: jared still > INET: jkstill@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@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@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@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). ------_=_NextPart_001_01C065F2.519AA4A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: IOT Vs Normal Tables

Any other known complications?

Alex Hillman

-----Original Message-----
From: Rachel Carmichael [mailto:carmichr@hotmail.com]
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@teleport.com>
>Reply-To: ORACLE-L@fatcity.com
>To: Multiple recipients of list ORACLE-L = <ORACLE-L@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@teleport.com
>jared_still@enron.net
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: jared still
>   INET: jkstill@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@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@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@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 =