Kbase P16106: Slow performance creating records after manually add Modific
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/03/2003 |
|
Status: Unverified
FACT(s) (Environment):
MS SQL DataServer
FACT(s) (Environment):
MS SQL 2000
SYMPTOM(s):
Slow performance creating records after manually add Modification Tables to Support the ROWID Function
Added PROGRESS_RECID column and triggers
CAUSE:
Incomplete implementation of the Support the ROWID Function. Missing create the index with PROGRESS_RECID column
FIX:
Change or create the non-unique indexes so that they include a PROGRESS_RECID column as the last component as follows:
create index table##index on table (column, PROGRESS_RECID)