Subject | RE: [firebird-support] Delete the contents of a given index |
---|---|
Author | Alan McDonald |
Post date | 2006-02-16T09:44:54Z |
> Is it there a sentence that lets me delete all the contents of ano such thing as "delete the contents"
> 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
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