Message-Id: <10660.120217@fatcity.com> From: "Rachel Carmichael" Date: Wed, 25 Oct 2000 20:19:31 GMT Subject: RE: Re[2]: Re[2]:Upgrading Oracle It isn't that I can't create indexes (and they aren't candidates for bitmap because they can and will be updated as people elect to receive or stop receiving the email newsletter).... it's that there are (right now) 9 choices of newsletter. And that number can grow at will, as the marketing people come up with new ideas for mailings. So... I'd start with 9 indexes on that table (well, 10 as I need a primary key one). Then I'd be adding new rows regularly, updating existing rows and possibly adding new columns that would need to be indexed. What happens if we end up with something like 50 possible mailings? 50 indexes on the table? >From: "Adams, Matthew (GEA, 088130)" >Reply-To: ORACLE-L@fatcity.com >To: Multiple recipients of list ORACLE-L >Subject: RE: Re[2]: Re[2]:Upgrading Oracle >Date: Wed, 25 Oct 2000 07:20:27 -0800 > >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@appl.ge.com > No electrons were harmed in the making of this e-mail. > > > > > -----Original Message----- > > From: Rachel Carmichael [mailto:carmichr@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@vicr.com > > >To: "Rachel Carmichael" , > > Multiple recipients > > >of list ORACLE-L > > >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@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@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@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@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). _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.