Using the Analyze Database Data wizard

You can analyze tables in a database using the Analyze Database Data wizard.

The wizard is available from
  • The Tools > Analyze Database Data menu

  • The Object > Database > Analyze DB Data menu

  • The context menu of a database node in the object explorer tree

You can select the tables to analyze and the data checks to perform on the selected tables. The operations include:
  • Optimization of columns that are declared NULL and hold no NULL values; optimization of character columns length, precise numeric columns, and integer columns

  • Primary key validation

  • Unique key validation

  • Checking of referential integrity

  • Checking for big data skew

  • Checking for tables that need to be reclaimed


Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk