ANALYZE TABLE


We can use the ANALYZE TABLE statement to review and store the key distribution in a table. MySQL stores this information and uses it to decide how to execute joins. You can run this statement by typing

 
 analyze table  tablename  ; 


MySQL Tutorial
MySQL Tutorial
ISBN: 0672325845
EAN: 2147483647
Year: 2003
Pages: 261

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net