Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Index Maintenance: Another Oracle Gem

Re: Index Maintenance: Another Oracle Gem

From: joel garry <joel-garry_at_home.com>
Date: 17 Oct 2006 11:35:10 -0700
Message-ID: <1161110110.290003.218640@e3g2000cwe.googlegroups.com>

hpuxrac wrote:
> DA Morgan wrote:
> > Have you ever wanted to rebuild all of the indexes in a list of schemas?
> > Indexes on a list of tables? A list of indexes or a list of index
> > components?
>
> Modern thinking about oracle indexes has shown almost all of these
> types of exercises to be at best a waste of time and resource.

Keeeeeriiiiist John, haven't you ever built a bunch of indices _after_ an import?

jg

--
@home.com is bogus.
http://babelfish.altavista.com/babelfish/trurl_pagecontent?lp=ja_en&url=http%3A%2F%2Fwww.mcd-holdings.co.jp%2Fnews%2F2006%2Frelease-061013.html
Received on Tue Oct 17 2006 - 13:35:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US