Re: De-fragmenting tables. Some questions

Dave Otto wrote in message <68b897$p8p$1@uxas10.themoneystore.com>... >Note that if there are any dependencies (FKs, Multi-table views, >etc.) you will need to drop these also and re-declare them. Be warned, however, that dropping and re-adding keys (foreign keys especially) will take scads of time, because the key-creation and validation process is still single-threaded. It won't be multi-threaded until at least 7.3 (not yet available). - Thomas J. Girsch Database Systems Manager Arch Communications Group, Inc. (513) 530-2500