Subject RE: [firebird-support] Delete the contents of a given index
Author Alan McDonald
> Is it there a sentence that lets me delete all the contents of a
> given index in my database or at least recompute the index
> contents. I prefer delete all if contents if I can. I only want
> to delete its contents not the index itself
>
> Thanks in advance
>
> Lorenzo

no such thing as "delete the contents"
delete the index if you don't need it.
recompute the index of you've just inserted wads of data.
set it inactive if you don't want the trivial overhead of maintaining it
during data insertion.
recreate it when you want it.
Alan