On 4/16/02 2:34 PM, "Lisi" <[EMAIL PROTECTED]> wrote:
> Thanks for the explanation! Very clear.
> How do you know how fragmented your DB is? I apologize if this is covered
> somewhere, like I said I was very confused buy this whole topic.
Oh, sorry each database is different but for MySQL it's:
SHOW TABLE STATUS FROM ... LIKE ...
In MS SQL it's:
In Informix it's:
onstat (-something I forget which but there help in onstat)
I forget Oracle but it's somewhere in the Enterprise manager...
Poet, Artist & Mystic
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php