No there is not a single bitmap indexes. We had previously but than removed
all and converted to normal b-tree indexes.
- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Wednesday, September 04, 2002 4:58 PM
> Marul,
>
> Are there any bitmapped indexes on the table
>
> Iain Nicoll
>
> -----Original Message-----
> Sent: Wednesday, September 04, 2002 11:28 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Marul,
>
> 10k records in 1 hour(3600 seconds)
>
> 1 record in 3600/10000 => approx 0.36 seconds
>
> If your application is OLTP you'll be inserting records 1 by 1 rather than
> in
> bulk. Which means the effect will hardly be noticed.
>
> If you are going to insert record in bulk you can DROP and then recreate
the
> indexes after load.
>
> Check what takes more time.
>
> See if there is any scope of partitioning the table, to use local
> partitioned
> indexes.
>
> For bulk load, disabling the constraints is also an option.
>
> Naveen
>
> -----Original Message-----
> Sent: Wednesday, September 04, 2002 3:13 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Thanks for the immediate reply
> But my requirement is such that I cannot reduce the indexes. There are
lots
> of selects happeneing on this table based on these indexed columns. Our
> entire application is about to move in the production environment and we
> cant change our DB design at this time.
>
> Please suggest
>
> TIA,
> Marul.
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, September 04, 2002 1:33 PM
>
>
> > Yep and you have given the answer yourself. It is the number of indexes.
I
> > think that if the number of records increase the number of levels
increase
> > and slowly but surely you need to update more and more blocks. I have
done
> > sone tests (an oher people I am sure) that show that there is an
expontial
> > increase in the amount of undo and redo generated for every index that
> gets
> > added into the mix.
> >
> > You will probably see an increase in CPU time (assuming that you are the
> only
> > process/session on the system).
> >
> > Anjo.
> >
> >
> > On Wednesday 04 September 2002 08:53, you wrote:
> > > Hi All,
> > >
> > > We have a table which can contain more than half a million records.
When
> we
> > > try to insert some 10k records in the empty table it get inserted in
10
> > > min. but as the size increases time taken to insert also increases.
> After
> > > 350,000 records it takes around an hour to insert 10k records. There
are
> > > around 15 columns in it out of which 11 are indexed. There is one
> > > concatenated function-based index on two columns of Varchar type and
two
> > > separate index for the same two columns.
> > >
> > > I have checked the free space for the tablespaces to which the table
and
> > > indexes are attached to. They are in two separate tbs.
> > >
> > > Any clues why this is happenning.
> > >
> > >
> > > TIA
> > > Marul.
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Anjo Kolk
> > INET: anjo_at_oraperf.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).
> >
> >
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Marul Mehta
> INET: marul_at_zycus.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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Naveen Nahata
> INET: naveen_nahata_at_mindtree.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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nicoll, Iain \(Calanais\)
> INET: iain.nicoll_at_calanais.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).
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Marul Mehta
INET: marul_at_zycus.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 Thu Sep 05 2002 - 01:18:23 CDT
