IOT Tuning Question

From: Jay Wade <fish_dba_at_hotmail.com>
Date: Thu, 20 Nov 2003 07:44:59 -0800
Message-ID: <F001.005D744A.20031120074459@fatcity.com>

Hello:

I'm looking at trying to tune a 3rd party app and was wondering if anyone could tell me if my assumptions are on base. The table contains three columns, each is part of the primary key, with about 1 million + rows. I figured that it would be an ideal candidate for using a partitioned IOT, but since records are frequently inserted am I correct in assuming that it would be better to use regular partitioned table using a primary key? Since this is a 3rd party application I can't change much of the layout, if anyone has any ideas it would be greatly appreciated.

Regards,
Jay

---

Groove on the latest from the hot new rock groups! Get downloads, videos, and more here. http://special.msn.com/entertainment/wiredformusic.armx

--

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

Author: Jay Wade
  INET: fish_dba_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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 Thu Nov 20 2003 - 09:44:59 CST