User's Guide

Part VI. SQL Anywhere Reference

Chapter 43. Watcom-SQL Statements

Function

To reset optimizer statistics.

Syntax

     DROP OPTIMIZER STATISTICS

Usage

Anywhere.

Permissions

Must have DBA authority.

Side effects

None.

Description

The DROP OPTIMIZER STATISTICS statement resets optimizer statistics. The SQL Anywhere optimizer maintains statistics as it evaluates queries and uses these statistics to make better decisions optimizing subsequent queries. These statistics are stored permanently in the database. The DROP OPTIMIZER STATISTICS statement resets these statistics to default values. This statement is most useful when first learning about the optimizer. It helps to better understand the process used by the optimizer.