| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Index query
We are using oracle 8.1.7 and solaris 5.7. -Seema
>From: "Charlie Mengler" <charliem_at_mwh.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Index query
>Date: Fri, 06 Apr 2001 09:15:49 -0800
>
>Depending upon the version of Oracle; which you neglected to mention,
>and depending upon whether or not you are using bit-mapped indexes
>and depending upon if you are doing inserts into the associated
>table, bit-mapped indexes grow exponentially with inserts!
>
>At least the bit-mapped indexes did/do so for use on all versions
>of 8i on V2.6 Solaris.
>
>Seema Singh wrote:
> >
> > Hi
> > My Index tablespace increasing so fast.WHat could be problem.What are
>the
> > things to be consider to better manage of Indexes.
> > Thanks
> > -Seema
> > _________________________________________________________________
> > Get your FREE download of MSN Explorer at http://explorer.msn.com
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Seema Singh
> > INET: oracledbam_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).
>
>--
>Charlie Mengler Maintenance Warehouse
>charliem_at_mwh.com 10641 Scripps Summit Ct
>858-831-2229 San Diego, CA 92131
>The future is here. It is just not evenly distributed.
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Charlie Mengler
> INET: charliem_at_mwh.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: Seema Singh INET: oracledbam_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).Received on Fri Apr 06 2001 - 13:20:38 CDT
 |
 |