RE: Index Organized tables: Please explain use?

From: Suri, Deepak <DSuri_at_oxhp.com>
Date: Fri, 10 Nov 2000 11:01:50 -0500
Message-Id: <10676.121723@fatcity.com>

That's the one Hannah !

Hey, and I really like your approach of going through the Oracle "Bible(s)". I can remember a time when I used to find time to do that myself, and I used to love it ! Please don't hesitate to throw any questions/comments you have to the wonderful folks on this list, I am sure everyone will appreciate it.

Oh and by the way while we are on the topic of lack of time, does anyone know of a way to request more than 24 hours in a day ??? :-)

deepak

-----Original Message-----

From: Hannah.M.Doran_at_sb.com [mailto:Hannah.M.Doran_at_sb.com] Sent: Friday, November 10, 2000 10:07 AM To: Multiple recipients of list ORACLE-L Subject: RE: Index Organized tables: Please explain use?

Are you referring to the Index Internals Article by dan Hotka? If so, looks
like it is still current, and I found it. Thanks.

Hannnah

"Suri, Deepak" <DSuri_at_oxhp.com> on 11/10/2000 09:05:50 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

There was an excellent explanation on IOTs in "Oracle Professional" by Pinnacle Publications a few issues ago. You might be able to find it in their archive at www.pinpub.com
Let me know if you can't find it, and I'll dig up my issue and fax you a copy...

deepak

-----Original Message-----

Sent: Friday, November 10, 2000 7:05 AM
To: Multiple recipients of list ORACLE-L

Hello List!

I'm having trouble comprehending the idea of an Index Organized table. The
Oracle 8i DBA Bible has this paragraph in it:

An index-organized table is one in which the entire table is created as an
index. All the data is stored in the index, and there

really is no underlying table. Oracle 8i allows secondary indexes to be
created on these tables, allows them to store large

objects, and allows you to add or modify columns using the ALTER TABLE command.

This is all they wrote. But I dont understand how/why one would store data in
the actual index. And if you create an index, don't you need to create it on a
specific table? And if there is NO table, then HOW could you create and index
on it. And why would you do it even if you could?

Thanks in advance,

Hannah

P.S. I have decided to go through the *bible* with a fine tooth comb in order
to deeply ingrain Oracle 8i (use only 7.34 at work still!), hope you don't mind
posts asking for clarification. My goal is to get through the entire book stopping to clarify anything that I do not fully 120% grasp or understand:>

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Hannah.M.Doran_at_sb.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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Suri, Deepak
INET: DSuri_at_oxhp.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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Hannah.M.Doran_at_sb.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