Hi,
We have recently moved a table which was replicated in 5 databases into a single one. A lot of the tables in each of the databases had indexes referencing a field in the table. Apart from this change, we haven't done anything else.
Since the move there seems to be a degradation in performance ... we think it could be due to problems with the indexes?
Any guidance as to why this would occur, or how to pinpoint the problem?
Winnt 4.0
Progress 9.1d.
We have recently moved a table which was replicated in 5 databases into a single one. A lot of the tables in each of the databases had indexes referencing a field in the table. Apart from this change, we haven't done anything else.
Since the move there seems to be a degradation in performance ... we think it could be due to problems with the indexes?
Any guidance as to why this would occur, or how to pinpoint the problem?
Winnt 4.0
Progress 9.1d.