Re: Do Analyze Table before Optimize Table or the other way around??

2004-08-10 Thread Egor Egorov
Scott Fletcher [EMAIL PROTECTED] wrote: I wanna know is do I do the Analyze the table before the Optimize the table or should I do it the other way around??? If you need to defragment the table, you can just run OPTIMIZE TABLE. -- For technical support contracts, goto

Do Analyze Table before Optimize Table or the other way around??

2004-08-09 Thread Scott Fletcher
I wanna know is do I do the Analyze the table before the Optimize the table or should I do it the other way around??? Thanks, FletchSOD