Best unofficial Apache Server developers community
Username
Forgot password?
Sign in with Twitter account
Sign in with Facebook account

Alternative queries equivalent to Oracle's Analyze Table Query

⇧
5
⇩
43 views

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

mysql sql-server oracle
asked June 10, 2011 3:24 pm CDT
Optiplex980
posted via StackOverflow

2 Answers

⇧
2
⇩
 

MySQL has ANALYZE TABLE as well, see here:

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

answered June 10, 2011 4:23 pm CDT
Johan
⇧
0
⇩
 

Have a look at SQLServer-DBA.com at this page for a statistics overview and another page on how to gather statistics in MS SQL Server. I don't know of other vendor implementations.

answered June 10, 2011 4:23 pm CDT
DCookie

Your answer

Join with account you already have

Sign in with Twitter account
Sign in with Facebook account
Sign in with Google Friend Connect

Preview
Similar questions
Mysql equivalent to access stored queries
February 1, 2011
Do I have too many queries for lookup tables and can anyone suggest an alternative?
April 21, 2011
MySQL Query Help - Multiple queries to same table
April 20, 2011
MySQL Table inside Table or Alternative
January 29, 2011
MySQL: View vs Temporary Table for optimizing/reducing queries and nested loop queries
March 13, 2011
Source for Oracle's MySQL installer for Mac
March 22, 2011
Tried to repair large MySQL table table that throws "126: Incorrect key file for table" error only with Update queries
March 10, 2011
Alternative to block a table.
April 23, 2011
CakePHP alternative to Class Table Inheritance?
April 29, 2011
Alternative for CREATE VIRTUAL TABLE IF NOT EXISTS
February 15, 2011
MySQL: how to do row-level security (like Oracle's Virtual Private Database)?
April 2, 2011
PostgreSQL - equivalent version of a table declared in MySQL?
March 2, 2011
Is there a mysql equivalent of show create table in postgres???
February 6, 2011
Redis newbie - equivalent approach to mysql table
February 6, 2011
Is there an easy way to turn a MySQL table into a Redis equivalent?
April 11, 2011
MySQL query equivalent of "AND", whereas "IN" is "OR"?
June 5, 2011
Alternative to a Filtered Sub-query
June 9, 2011
Sp_depends equivalent query in postgresql
March 22, 2011
Average of a grouped sum alternative query - MySQL
May 10, 2011
CakePHP parsing query results alternative
May 18, 2011
Whats an alternative way of updating a page with new records as they are inserted into a table automatically without using jquery/ajax.
April 4, 2011
Any way to analyze locks after the fact?
May 21, 2011
Postgres Analyze performed
April 20, 2011
Oracle's Sun Flash Storage with MySql [Smart Flash cache optimization]
May 19, 2011
Tools to analyze traffic through a firewall?
February 22, 2011
Viewing/analyze all database accesses in Django
January 12, 2011
How to analyze which virtual host account is most greedy?
January 24, 2011
Best way to analyze http traffic sent by my java code?
January 31, 2011
Postgresql: what order should I cluster reindex and analyze?
February 11, 2011
Efficiently creating a database to analyze relationships between information.
February 21, 2011