RE: Re[2]: Re[2]:Upgrading Oracle

From: Jim Conboy <Jim.Conboy_at_trw.com>
Date: Wed, 25 Oct 2000 10:33:39 -0700
Message-Id: <10660.120187@fatcity.com>

Some very good ideas here. Unfortunately with third party apps its often = not feasible to go in and make your own changes. Can cause problems with = upgrades, not to mention product warranties from the vendor.

Jim

>>> jklopping_at_oppd.com 10/25/00 01:56PM >>> 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...=20

> -----Original Message-----
> From: Jeffery Stevenson [SMTP:jeff_at_mpv.com]=20
> Sent: Wednesday, October 25, 2000 11:35 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Re[2]: Re[2]:Upgrading Oracle

>=20

> 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. :)

>=20

> Jeff

>=20

> -----Original Message-----
> Sent: Wednesday, October 25, 2000 10:20 AM
> To: Multiple recipients of list ORACLE-L

>=20
>=20

> Rachael,

>=20

> Why can't you create indexes on these columns?
> (offhand they sound like candidates for bitmapped=20
> indexes)

>=20

> Matt

>=20

> ----
> R. Matt Adams - GE Appliances - matt.adams_at_appl.ge.com=20
> No electrons were harmed in the making of this e-mail.

>=20
>=20
>=20


> > -----Original Message-----

> > From: Rachel Carmichael [mailto:carmichr_at_hotmail.com]=20

> > Sent: Wednesday, October 25, 2000 12:06 AM

> > To: Multiple recipients of list ORACLE-L

> > Subject: Re: Re[2]: Re[2]:Upgrading Oracle

> >=20

> >=20

> >=20

> > oh that was minor compared to today's rant... a third party=20

> > product that=20

> > denormalizes tables because their "experts" told them that if=20

> > you have more=20
> > than 4 tables in a join performance suffers significantly.
o send the HELP command for other information (like subscribing). Received on Wed Oct 25 2000 - 12:33:39 CDT