I always find it amusing that the SDD_ELEMENTS table
which is part of an Oracle product meant to encourage
good design (ie Designer) has more than this number of
indexes :-)
- Jared Still <jkstill_at_cybcon.com> wrote: >
> Hope I'm not being blunt here, ( I will admit to
> being frank, but not Frank )
>
> What you're suggesting here is to put a patch on a
> bad design.
>
> 15 indexes? That's too many.
>
> Your table is undoubtedly highly denormalized and
> has too
> many columns. How many columns does this table
> have?
>
> You really need to take a step back and look at the
> design
> of the data you are querying.
>
> If this is really critical data ( Contracts? Sounds
> critical ) then
> strongly consider bringing in a consultant with
> strong data modeling
> and database design experience to help you put this
> data in
> a manageable form.
>
> Or maybe you need to build a data mart and use
> partitioning?
>
> This sounds to me like you need more consulting that
> you can
> get from a few emails on a list server.
>
> Jared
>
>
>
> On Monday 10 December 2001 19:50, Tatireddy,
> Shrinivas (MED, Keane) wrote:
> > Hi lists,
> >
> > Can anybody help me...?
> >
> > Table CONTRACTS is accessed by many applications
> and has many selects
> > hit this table. This table has 15 indexes.
> >
> > Still It needs some more indexes. But we were
> instructed to stop
> > creating indexes.
> >
> > We have another table CONT2 in another schema.
> This table is copy of
> > CONTRACTS.
> >
> > Is there a way to write a trigger on CONT2 for the
> following issue:
> >
> > if a particular select / select statement issued
> against CONTRACTS
> > table, that query should select data from CONT2.
> >
> > (There is only one particular select statement
> that is more resource
> > intensive. We need to divert that query to CONT2.
> As the applications
> > are already tuned, we were not permitted to modify
> that code.)
> >
> > Thnx in advance,
> >
> > Srinivas
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Jared Still
> INET: jkstill_at_cybcon.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).
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
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 Tue Dec 11 2001 - 14:29:09 CST
