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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Replication of indexes

Re: Replication of indexes

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 07 Sep 2005 16:41:22 +0200
Message-ID: <dfmto8$brv$2@news5.zwoll1.ov.home.nl>


Bing Wu wrote:
> Frank van Bortel wrote:
>

>> Why would you replicate indexes?!?
>> The PK index on the master ensures data is unique - before
>> it is replicated.

>
>
> I have large tables distributed which enables to be queried locally. The
> indexes are just regular indexes to increase query performance. You
> always need indexes on frequently queried fields.
>
> Thanks,
>
> Bing

Never say never... or always.
But you have a point.

What's wrong with creating the indexes?

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Wed Sep 07 2005 - 09:41:22 CDT

Original text of this message

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