Thanks a lot to all who have contributed their experiences and ideas for
thsi problem.
I have to look into the application and business details whether this is
feasible or not. Have to talk to our tech head.
Marul.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
If adding 400 records slows down the system, I guess it is time to take a
hard look at your set-up and see where the problems are occurring by
measuring and analyzing the waits in the database.
How did you establish that balancing indexes causes the delay? No matter
what kind of solution you
Subject: RE: Disabling indexes -
temporarily
Firstly, you are only inserting 100-400 records daily, which is not a
big deal. Even if there was a way to stop the indexesfrom
gettingupdated, it won't increase the performance by a noticable
amount.
Secondly, there isno way(asfar
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Marul MehtaSent:
Monday, September 02, 2002 2:38 PMTo: Multiple recipients of list
ORACLE-LSubject: Re: Disabling indexes -
temporarily
Thanks Naveen,
Lets forget aboutthe statistics
Could you have a trigger which before insert, inserts into another empty
table with exactly same layout but rejects the insert on the main table.
Then disables the trigger and adds these at a non-busy stage and reenables
the trigger. Would be a whole lot quicker if it's possible.
Iain,
thats a fantastic idea.
Naveen
-Original Message-
Sent: Monday, September 02, 2002 5:28 PM
To: Multiple recipients of list ORACLE-L
Could you have a trigger which before insert, inserts into another empty
table with exactly same layout but rejects the insert on the main table.
6:38
PM
Subject: Re: Disabling indexes -
temporarily
Thanks Naveen,
Lets forget aboutthe statistics and
performance, but I have such type of requirenment than is there any way out
?
Marul.
- Original Message -
From:
Naveen Nahata
To: Multiple
Firstly, you are only inserting 100-400 records daily, which is not a big
deal. Even if there was a way to stop the indexesfrom
gettingupdated, it won't increase the performance by a noticable
amount.
Secondly, there isno way(asfar as i know)to make the
indexes READ-ONLY with the table in