| 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: Re[2]: Re[2]:Upgrading Oracle
first, we are talking something on the order of 15 million or more rows
second we will be adding new columns on a semi-regular basis -- automated so that I won't know when one is added, new indexes need to be added then
>From: "KLOPPING, JEFFREY L" <jklopping_at_oppd.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Re[2]: Re[2]:Upgrading Oracle
>Date: Wed, 25 Oct 2000 09:56:48 -0800
>
>Sounds like a perfect candidate for a bitmapped index...
>drop it before updating and create it after...
>one table scan then after that the rest is done in memory...
>
>
> > -----Original Message-----
> > From: Jeffery Stevenson [SMTP:jeff_at_mpv.com]
> > Sent: Wednesday, October 25, 2000 11:35 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Re[2]: Re[2]:Upgrading Oracle
> >
> > Sounds like the tables will be having too many updates/inserts to make
> > bitmap indexes feasible. She could possibly split the table up and then
> > create a view to map it back to the way the application expects to see
>it
> > (even using INSTEAD-OF triggers to map inserts and updates properly).
> > Well,
> > she'll figure something out. :)
> >
> > Jeff
> >
> > -----Original Message-----
> > Sent: Wednesday, October 25, 2000 10:20 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Rachael,
> >
> > Why can't you create indexes on these columns?
> > (offhand they sound like candidates for bitmapped
> > indexes)
> >
> > Matt
> >
> > ----
> > R. Matt Adams - GE Appliances - matt.adams_at_appl.ge.com
> > No electrons were harmed in the making of this e-mail.
> >
> >
> >
> > > -----Original Message-----
> > > From: Rachel Carmichael [mailto:carmichr_at_hotmail.com]
> > > Sent: Wednesday, October 25, 2000 12:06 AM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Re: Re[2]: Re[2]:Upgrading Oracle
> > >
> > >
> > >
> > > oh that was minor compared to today's rant... a third party
> > > product that
> > > denormalizes tables because their "experts" told them that if
> > > you have more
> > > than 4 tables in a join performance suffers significantly.
> > >
> > > So instead of a parent table with a child table that contains
> > > one row for
> > > each option selected, I have ONE table with a column for
> > > every possible
> > > option, and a Y/N switch for each one. AND just to make it even more
> > > interesting, if you want to add a new option, the product
> > > automatically adds
> > > a new column to the table. We expect to have something like
> > > 5-15 million
> > > rows in that table. And we will do selections for mass emails
> > > based on each
> > > of those columns. Which I can't index, so we will do multiple
> > > full table
> > > scans on a table way too large to pin into the buffer pool.
> > >
> > > I managed not to foam at the mouth. And made sure that
> > > EVERYONE in that
> > > meeting knew that I thought that this design was going to
> > > cause us major
> > > performance problems that I could not necessarily do DBA
> > > magic to remove.
> > > Sigh......
> > >
> > > Rachel
> > >
> > > >From: dgoulet_at_vicr.com
> > > >To: "Rachel Carmichael" <carmichr_at_hotmail.com>,
> > > Multiple recipients
> > > >of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > > >Subject: Re[2]: Re[2]:Upgrading Oracle
> > > >Date: Tue, 24 Oct 2000 18:35:20 -0400
> > > >
> > > >Nice to see I can still get a rise out of you. Cheers!!
> > > >
> > > >Dick Goulet
> > >
> > > ______________________________________________________________
> > > ___________
> > > Get Your Private, Free E-mail from MSN Hotmail at
> > http://www.hotmail.com.
> >
> > Share information about yourself, create your own public profile at
> > http://profiles.msn.com.
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Rachel Carmichael
> > INET: carmichr_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).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Adams, Matthew (GEA, 088130)
> > INET: MATT.ADAMS_at_APPL.GE.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: Jeffery Stevenson
> > INET: jeff_at_mpv.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: KLOPPING, JEFFREY L
> INET: jklopping_at_oppd.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).
 |
 |