Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Index Organized tables: Please explain use?

RE: Index Organized tables: Please explain use?

From: Suri, Deepak <DSuri_at_oxhp.com>
Date: Fri, 10 Nov 2000 09:04:37 -0500
Message-Id: <10676.121704@fatcity.com>


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-----
From: Hannah.M.Doran_at_sb.com [mailto:Hannah.M.Doran_at_sb.com] Sent: Friday, November 10, 2000 7:05 AM
To: Multiple recipients of list ORACLE-L Subject: Index Organized tables: Please explain use?

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). Received on Fri Nov 10 2000 - 08:04:37 CST

Original text of this message

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