gt; >
> > Are you targeting certain indexes that have been identified as
> > benefiting from a rebuild, or just planning to rebuild all indexes?
> >
> > Jared
> >
> >
> >
> >
> > renu r <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
&
e bacause the size of table is big so it is not definitive. I
> will
> > > check the level after rebuild.
> > >
> > > Benefits expected : Space savings (definitely). performance (hopefully).
> I
> > > will let you and Yong know about the benefits if any. If I
/2003 02:59 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> cc:
> Subject:Re: any problem rebuilding indexes used for
> replication
>
>
> renu (and Jared),
>
> T
> > What benefits do you expect from the rebuild of the indexes?
> >
> > Are you targeting certain indexes that have been identified as
> > benefiting from a rebuild, or just planning to rebuild all indexes?
> >
> > Jared
> >
> >
> >
> >
>
t ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: any problem rebuilding indexes used for replication
renu (and Jared),
The reason I'm very interested in whether there's performance improvement is
that there's a thread on the newsgroup about index rebu
t;
>
> renu r <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 11/05/2003 06:14 PM
> Please respond to ORACLE-L
>
>
> To:Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc:
> Subject:
ACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: any problem rebuilding indexes used for replication
Jared : I think it is fragmented based on scripts and knowing that there have been lot of deletes.
One
Jared : I think it is fragmented based on scripts and knowing that there have been lot of deletes.
One script uses the table index_stats and looks at field del_lf_rows which should be less at least in comparison to field lf_rows. I mean less is good. more bad. I am not sure about the script but
D]>
Sent by: [EMAIL PROTECTED]
11/05/2003 06:14 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: any problem rebuilding indexes used for replication
Hello,
I have to rebuild
Hi, renu,
I'll let experts anwser your question. But I have a request for you. Before and
after you rebuild (or coalesce) your indexes, please make close observation on
your application performance, as well as the statistics and sizes of the
indexes. I'd like to know whether rebuilding them actual
Hello,
I have to rebuild some primary key indexes due to excessive fragmentation. It is rebuild not drop and create. We have multi master replication running. Is there any problem to replication if I do that. Has anyone tried it? TIA.
Do you Yahoo!?
Protect your identity with Yahoo! Mail Address
11 matches
Mail list logo