Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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).Received on Tue Dec 11 2001 - 09:46:47 CST
![]() |
![]() |