Geek asks and answers

Alternative queries equivalent to Oracle Analyze Table Query

Are any queries in other databases equivalent to Oracle very useful ANALYZE TABLE..? I am looking for alternatives for the following database providers:

  • MySQL
  • MS SQL Server [2000, 2005, 2008]

Thanks in advance

+3
source share
2 answers

MySQL has ANALYZE TABLE, see here:

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

+2
source

Take a look at SQLServer-DBA.com on this page for an overview of statistics and another page on how to collect statistics in MS SQL Server. I do not know other vendor implementations.

, SQL Server CREATE STATISTICS, .

0

More articles:


All Articles