}
} >
} > At 09:53 PM 12/23/94 -0500, Borg Boy wrote:
} > >Question: Will unloading a database using tbunload, then dropping it, and
} > >loading it back in using tbload defrag the tables?
} > >
} Jon Vemo sez:
} > NO. tbunload performs a binary unload of each page, page for page. Any
} > fragmentation which existed before, will still be there after tbload'ing.
} >
}
} I thought 'tbunload,drop,tbload' was one of the sanctioned methods for
} defragging disc space. What does one use?
}
tbload/tbload does re-extent tables. What it doesn't do is shrink tables
that have had many rows deleted. For that you have to unload/dbload the
table.
--
Naomi Walker (aka N7FSA) | naomi@anasazi.com
| Phoenix, Arizona
-----------------------------------------------------------------
Dyslexsics, Untie! | Visualize Whirled Peas