Kbase P74821: What is the fastest way to delete an index
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/02/2005 |
|
Status: Unverified
GOAL:
What is the fastest way to delete an index
GOAL:
What is the best way to delete an index
FACT(s) (Environment):
Progress 9.x
FIX:
If an index is in its own area then, as long as the database isn't running, the fastest way to remove an index is by truncating the area the index is in.
proutil <dbname> -C truncate area "area name"
If an index is not in its own area then the only way to release the blocks of that index back to the database for other uses is to drop the index programatically or thru the database dictionary.
There is a reduction of BI notes when using the truncate area option compared to the Drop Index option.