RE: OLTP help

From: Herring Dave - dherri <Dave.Herring_at_acxiom.com>
Date: Fri, 18 Aug 2006 11:36:46 -0500
Message-ID: <7ED53A68952D3B4C9540B4EFA5C76E3602217D39@CWYMSX04.Corp.Acxiom.net>

Thanks Brandon (and all others for their responses).

My mention of a PK was in the logical design sense - nothing physical, just logically designed as such.

Dave

Dave Herring, DBA

Acxiom Corporation

3333 Finley

Downers Grove, IL 60515

wk: 630.944.4762

<mailto:dherri_at_acxiom.com <mailto:dherri_at_acxiom.com> >

"When I come home from work and see those little noses pressed against
the windowpane, then I know I am a success" - Paul Faulkner

From: Allen, Brandon [mailto:Brandon.Allen_at_OneNeck.com] Sent: Friday, August 18, 2006 11:34 AM
To: Herring Dave - dherri; oracle-l
Subject: RE: OLTP help

Hi Dave,

I've never been a fan of multiple sized tablespaces because of the complication & segregation it introduces to your buffer cache. I would recommend just looking at the top queries on the table and if they are consistent (e.g. not 1-time queries), then tweak them or add indexes, or hints, stored outlines, etc. in order to optimize them. How can the PK not have an associated index? I didn't know such a thing could exist. From the 9i doc
(http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adg 05itg.htm):

"All enabled unique and primary keys require corresponding indexes"

Regards,

Brandon

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged.

If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.

If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.

Thank you.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Aug 18 2006 - 11:36:46 CDT