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.
> 
> Thanks,
> 
> -Lisi
>

Oh, sorry each database is different but for MySQL it's:
  SHOW TABLE STATUS FROM ... LIKE ...

In MS SQL it's:
  sp_spaceused ...

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

Good Luck,
Frank

-- 
Frank Flynn
Poet, Artist & Mystic



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to