Alternative queries equivalent to Oracle's Analyze Table Query

Question

Are there queries in other databases equivalent to Oracle's very useful ANALYZE TABLE.. ? I am looking for alternatives for the following Database vendors:

1. MySQL
2. MS SQL Server [2000, 2005, 2008]

Thanks in advance

Answer 1

MySQL has ANALYZE TABLE as well, see here:

http://dev.mysql.com/doc/refman/5.5/en/analyze-table.html