| Introduce index post replication [message #610483] |
Thu, 20 March 2014 09:41  |
 |
sinpeak
Messages: 59
Registered: January 2011
Location: india
|
Member |
|
|
Hi,
Apologies in advance if this is not the right forum for my query.
Please direct me to the right one if this isn't the right one.
My client is going to replicate their DB on to another environment with same environment parameters.
There is a DB table with close to a million rows in each table.
Each row has 27 columns.
The table already has a unique index of 20 columns.
Post replication the client wants to create 4 normal indexes each with one column.
In such a situation, what should be done post replication apart from just firing the CREATE INDEX command.
Please advise.
Thanks.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
