Index definition on target differs from source due to application requirement.
Customers sometimes want to have a different index definition on target than that on the source. This is due to the nature of queries they run on target for reporting purposes. The way indexes are defined (e.g. composite), it can have a bearing on the query performance. As far as Shareplex is concerned, it does not matter if the target table has indexes which are different than that on the source table. Shareplex simply submits the SQL to the target database and the target database will use the index as appropriate.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center