Re: Alter index enable would be nice

From: Paul G Young <pgy_at_magma.ca>
Date: Mon, 06 Jul 1998 19:33:47 GMT
Message-ID: <01bda914$bd98f500$ec05bfce@default>

I'd like to reinforce Steve's concern. Oracle seems to live a black and white world while the rest of us live with a multitude of grays.

It's been my experience that a full system application to have three basic modes which have different processing characteristics vis-à-vis indexing:: 1. load into system - all write, no read: this is addressed by Oracle's direct loader - good - I never use it.
2. process data - balanced read, lot's of write: numerous indexes are a serious performance liability.
3. report information - little write, lot's of indexed reads. To provide reasonable performance and a multitude of access paths, a lot of indexes are required.
There is often good reason to keep these data together in the same tables on the same databases.

Clearly processing and reporting are at odds without any means to manage them. I was told (apparently incorrectly) by Oracle that with Oracle 8's partitioning feature, indexes could be controlled by partition. That is, partition A could have minimal indexing, while at the same time partition B could have reporting-level indexing. This appears not to be the case.

Any suggestions?

PGY
pgy_at_magma.ca.DROP_THIS

---

Steve Haynes <steve_at_rwx777.demon.co.uk> wrote in article <xuaYuIA69Un1Eww2_at_rwx777.demon.co.uk>...
> Dear All,
> One nice thing about constraints is the way you
> can just enable/disable and any related indexes
> are just rebuilt with original storage.
> I need to do this with indexes - its a real pain if you
> have many different sites with different storage, either
> you have to call a script or rescue all the storage
> stuff from user_indexes before the drop. messy and fiddly.
> I can't do alter index rebuild rebuild coz I need the
> index to be dropped whilst some heavy processing is done.
> The indexes are only to help queries once the main
> processing is complete.
> Oh well, oracle 9 maybe.
> Steve
> --
> "The floggings will continue until morale improves."
>
>
Received on Mon Jul 06 1998 - 14:33:47 CDT