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: [EMAIL PROTECTED]; 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).