Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-----
From: Adams, Matthew (GEA, 088130) [mailto:MATT.ADAMS_at_APPL.GE.COM]
Sent: Wednesday, October 25, 2000 10:20 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Re[2]: Re[2]:Upgrading Oracle
Rachael,
Why can't you create indexes on these columns? (offhand they sound like candidates for bitmapped indexes)
Matt
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 mayReceived on Wed Oct 25 2000 - 10:39:26 CDT