Contents Index Use bulk operations methods Try using Adaptive Server Anywhere's compression features

ASA SQL User's Guide
  Monitoring and Improving Performance
    Top performance tips

Use the WITH EXPRESS CHECK option when validating tables


If you find that validating large databases with a small cache takes a long time, you can use one of two options to reduce the amount of time it takes. Using the WITH EXPRESS CHECK option with the VALIDATE TABLE statement, or the -fx option with the Validation utility can significantly increase the speed at which your tables validate.

For information on improving performance when validating databases, see Improving performance when validating databases.


Contents Index Use bulk operations methods Try using Adaptive Server Anywhere's compression features