Re:IOTs

From: <dgoulet_at_vicr.com>
Date: Thu, 15 Mar 2001 14:53:09 -0800
Message-ID: <F001.002CE3EF.20010315134254@fatcity.com>

Russell,

IOT's in 8.0.x have no rowid's which is why one could not define any other indexes on the object. That has been fixed in 8.1.6+ since I've got some there and they do report a rowid. As for using them on insert intensive operations I think their a little bit faster than a regular table mainly because you get the table and index in one fell swoop. Now I definitely would not want to use one in a insert & delete intensive operation since "alter index <index_name> rebuild" does not work on IOT's, yet.

Dick Goulet

____________________Reply Separator____________________
Author: Russell Brooks <russell.brooks_at_amctechnology.com>
Date:       3/15/2001 7:01 AM

Hi,
We're thinking about defining an insert-intensive table as an IOT. Has anyone tried this? Any strong feelings pro or con? Also, I thought that IOTs used a universal rowid, but references in Metalink state that there is no rowid. Does anyone have any insights to offer?

Thanks,
Russ Brooks
--

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

Author: Russell Brooks
INET: russell.brooks_at_amctechnology.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:
INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------