RE: select data using trigger

Hi

Thnq for responding.

I am mistaken, in understanding the request.

I am supposed to create a trigger that will do update onto a target table con2 whenever the contract is updated.

15 indexes on a table:

There are several tables that have 15 indexes. All such tables will have 10-20,000 rows and are majorly used for querying.

They have around 10-30 columns.

But we never got a complaint, that the accessing is slow.

Is this a harmful situation, having 15 indexes on a table. (The table data almost never
grow)

Thnx and regards,

Srinvias

-----Original Message-----
Sent: Tuesday, December 11, 2001 11:56 AM To: ORACLE-L_at_fatcity.com; Tatireddy, Shrinivas (MED, Keane)

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: Tatireddy, Shrinivas (MED, Keane)
  INET: Shrinivas.Tatireddy_at_med.ge.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).