Replication and indexing...

2002-03-29 Thread Jeff Kilbride
Do the tables on the slave machine have to be *exactly* the same as the tables on the master? Is it possible to have different indexes on the slave? I want to use my master as my transaction server and my slave as my reporting server. In that respect, I'd like to use very few indexes on my master

Re: Replication and indexing...

2002-03-29 Thread Jeremy Zawodny
On Fri, Mar 29, 2002 at 01:13:50PM -0800, Jeff Kilbride wrote: Do the tables on the slave machine have to be *exactly* the same as the tables on the master? No. Is it possible to have different indexes on the slave? Yes. I want to use my master as my transaction server and my slave as my