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 some primary key indexes due to excessive
Jared : I think it is fragmented based on scripts and knowing that there have been lot of deletes.
Onescript uses the table index_stats and looks at field del_lf_rows which should be less at least in comparison to field lf_rows. Imean less is good. more bad. I am not sure about the script but I
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 script uses the table index_stats and looks
:
Subject:any problem rebuilding indexes used for replication
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
PROTECTED]
cc:
Subject:any problem rebuilding indexes used for replication
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
:any problem rebuilding indexes used for replication
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
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 rebuild recently. See
http
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:any problem rebuilding indexes used for
replication
]
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 some
Hello,
Ihave torebuild some primary key indexesdue to excessive fragmentation. It is rebuild not drop and create.We have multi master replication running. Is there any problem to replicationif I do that. Has anyone tried it? TIA.
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
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
11 matches
Mail list logo