Re: How many people here rebuid index regularly?

On Oct 8, 11:58 pm, Alberto Frosi <alberto.fr..._at_gmail.com> wrote:
> On 9 Ott, 00:08, joel garry <joel-ga..._at_home.com> wrote:

> > 42 rows selected.
>
> > SQL> select leaf_blocks from user_indexes where
> > index_name='IC_MOVEMENTS_2';
>
> > LEAF_BLOCKS
> > -----------
> > 118334
>
> > Therefore, exp/imp must indeed be the answer to life, indices and
> > everything! :-)
>
> > The question that is begged: Can-or-should I just compare the
> > leaf_blocks on all indices between production and test and rebuild
> > those with the largest difference? Seems too simple. (Especially
> > since I know if I mention this to this customer they will just want me
> > to exp/imp the whole db, MS-think abounds). I've never felt any need
> > to do anything to these indices, except due to the space issue -
> > between hardware upgrades and such, this is the first time they've
> > gone a couple of years with no maintenance.
>
> > jg
> > --
> > @home.com is bogus.http://www.signonsandiego.com/uniontrib/20071006/news_1b6halo.html
>
> Hi joel,
> i'm very surprised for this approach.
> i'm sorry but do you make these operation for know if your indexes
> must be rebuild?

No, I've never rebuilt any indexes on this db. I'm thinking about it now, for space reasons, not performance - I don't think there are any fast full index scans on this index, for instance. There's just a number of gigabytes of wasted space in this schema.

> Tell more please.

Jonathan is the expert :-)

http://en.wikipedia.org/wiki/Answer_to_Life%2C_the_Universe%2C_and_Everything

>

jg

--
@home.com is bogus.
I'd like to see nominations for the sysadmin from hell.
http://www.sysadminoftheyear.com/