you can deactivate an index. won't free up the space but it'll stop the
overhead of maintaining an index.
btw doesn't openedge sql have fast index drop, anyone ?
Code:
for first _file
where _file-name = "item",
first _index of _file
where _index-name = "itemnum":
_index._active = no.
or from the data admin ( maybe from architect but i don't have one )
to activate an index you can use the proutil idxbuild. don't know if
10.1a scans only the table' cluster or the entire area, still.
another thing i'm not sure about, off the top of my head, is if idxfix,
which uses another index to only scan that table, activates an index.
where are the docs when you need'em