>Hello All,
>I have a need to remove all index tags from my tables ( for performance reasons ) then reinstate them, I saw some code years ago that modified the header using low level functions,did something then set the header back as was, anyone have any ideas?
>
>Thanks
>Pete Kane
DELETE TAG ALL, is just about instantaneous for removing all index tags.
You'll have to re-create the indexes with new INDEX ON commands though.
Even if you had some way to 'magically' disconnect and reconnect the index file, you would still need to REINDEX the table after the procedure, so this would take the same amount of time as the strategy mentioned above.