Creating index on table at subscriber
From: Derek (Derek_at_discussions.microsoft.com)
Date: 09/02/04
- Next message: Wojtek Z: "Re: Is there an error in Help ?"
- Previous message: Bryan Bitzer: "Re: stored procedure across servers"
- Next in thread: Paul Ibison: "Creating index on table at subscriber"
- Reply: Paul Ibison: "Creating index on table at subscriber"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 1 Sep 2004 21:39:04 -0700
I have a database for a 3rd party application that I need to report from.
Since I can't do anything to the 3rd party database, I am replicating the
relevant tables to my own database and running the queries there.
One of the tables (Action table) has two fields (Datestamped, Timestamped),
which are critical to some complicated queries I'm running. However neither
of these fields have indexes in the 3rd party database (since they obviously
aren't important to the 3rd party application).
I want to create indexes at the subscriber, but am worried about the
following.
1) Can I do it without breaking the replication or the databases?
2) What will the maintenance be like for this? Will I need to recreate the
indexes every time I need to rebuild the replication?
Thanks in advance
Derek
- Next message: Wojtek Z: "Re: Is there an error in Help ?"
- Previous message: Bryan Bitzer: "Re: stored procedure across servers"
- Next in thread: Paul Ibison: "Creating index on table at subscriber"
- Reply: Paul Ibison: "Creating index on table at subscriber"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
