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