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: Bing Wu <bing_at_biop.ox.ac.uk>
Date: Wed, 07 Sep 2005 12:58:51 +0100
Message-ID: <dfmklr$chn$1@news.ox.ac.uk> 





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
Received on Wed Sep 07 2005 - 06:58:51 CDT












Original text of this message













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