<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

if u are very sure about the data, then how about
inserting these data into a temporary table until eod, and insert into actual
tables after ur busy hrs.

----- Original Message -----
Marul Mehta
To: Multiple recipients of list ORACLE-L

Sent: Monday, September 02, 2002 6:38
Subject: Re: Disabling indexes -

Thanks Naveen,
Lets forget about the statistics and
performance, but I have such type of requirenment than is there any way out


----- Original Message -----
Naveen Nahata
To: Multiple recipients of list ORACLE-L

Sent: Saturday, August 31, 2002 11:58
Subject: RE: Disabling indexes -

Firstly, you are only inserting 100-400 records daily, which is not a
big deal. Even if there was a way to stop the indexes from
getting updated, it won't increase the performance by a noticable

Secondly, there is no way(as far as i know) to make
the indexes READ-ONLY with the table in READ-WRITE mode.

Thirdly, rebuilding 20 indexes on a table with 1 million record will
take a long time, in comparison updation by 100-400 records is

neither feasible nor advisable.


-----Original Message-----From: Marul Mehta
Sent: Saturday, August 31, 2002 11:08
PMTo: Multiple recipients of list ORACLE-LSubject:
Disabling indexes - temporarily
Hi all,

Need to know if the following is possible in
Oracle(any version):-

I have a table of around
(a) 30
(b) 20 out of 30 are
(c) around 1 million
(1,000,000) records.

Most of the time there will be heavy reads
(select queries) on this table except for some 100-400 records to be
inserted in a day. The newly inserted records will not be selected by the
queries for the next 24 hours (this is based on some business logic),
thats for sure.

Now the problem is when ever a record(s) is
inserted the entire bunch of indexes is updated/rebuild by the Oracle
which considerably slows down the throughput of the system during that
period of time (until all indexes are updated).

Can we have a solution whereby indexes should
not be updated when a record(s) is inserted, because I know that these
records will not be the part of the query for the next 24 hrs. The indexes
will be re-built manually/scheduled during the off-peak hours once a day.
In this way, the next day, new records inserted a day before will be ready
to be fetched by the queries.

Note- I can't put my indexes offline not for
a single minute during peak hours.

Any clues?


Please see the official ORACLE-L FAQ: http://www.orafaq.com
Author: apmanikandan
INET: apmanikandan_at_hotmail.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).

Search Discussions

Discussion Posts


Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 5 of 7 | next ›
Discussion Overview
grouporacle-l @
postedSep 2, '02 at 10:38a
activeSep 3, '02 at 1:58p



site design / logo © 2022 Grokbase