Kbase P12282: How to avoid the Unique option for an index
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/01/2003 |
|
Status: Unverified
GOAL:
How to avoid the Unique option for an index
FACT(s) (Environment):
Progress/WebSpeed Versions
FIX:
Unique option cannot be changed for an index.
The index should be deleted and created without this option.
If the table has too much records the index could be created as inactive and then the index could be activated with the idxbuild tool.