RE: Indexing SYS tables

Thanks, Tom. That's the kind of feedback I'm looking for. Anyone else?

Rich

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: Mercadante, Thomas F [mailto:NDATFM_at_labor.state.ny.us]
> Sent: Tuesday, October 01, 2002 12:18 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Indexing SYS tables
>
>
> Rich,
>
> I think you're crazy adding indexes SYS tables. I would *never* add
> anything to sys objects. What are you going to do the first
> time something
> goes wrong and you call Oracle support and you "mention" you
> added an index
> and they say - hey, you're on your own! Not to mention that when you
> perform an upgrade, that this index may either get lost or be
> in the way.
>
> No, a totally bad idea.
>
> If anything, I would copy the audit records to a local table
> in your schema,
> and then index that baby anyway I'd like. That way, the
> system objects are
> the way that Oracle inteneded them to be.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).