Re: tbtape question

} 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? } > } NO. tbunload performs a binary unload of each page, page for page. Any } fragmentation which existed before, will still be there after tbload'ing. } } Jon } ================================================================== } Jon Vemo Internet: jvemo@cyberspace.com } Bothell, WA USA } ------------------------------------------------------------------ } Watch out for road-kill on the information superhighway....SPLAT!! } ================================================================== This is true as far as row level fragmentation is concerned but tbload does load all pages into a single extent when reloading. This means that you should get some performance benefits over a database which has its tables fragmented across many extents. Cheers - Jim My opinions are my own. They may vary with time but they remain MINE! ---------------------------------------------------------------------- Name: Jim Gordon Company: DHL Systems Inc, Burlingame, CA, USA ----------------------------------------------------------------------