RE: OLTP help
- From: "Herring Dave - dherri" <Dave.Herring@xxxxxxxxxx>
- To: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 18 Aug 2006 11:36:46 -0500
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@xxxxxxxxxx <mailto:dherri@xxxxxxxxxx> >
-------------------------------------
"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@xxxxxxxxxxx]
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.
*************************************************************************
Other related posts:
