} 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
----------------------------------------------------------------------