Re: select data using trigger

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).