Reference Manual
   CHAPTER 9. SQL Statements     

DROP OPTIMIZER STATISTICS statement

Function 

To reset optimizer statistics.

Syntax 

DROP OPTIMIZER STATISTICS

Permissions 

Must have DBA authority.

Side effects 

None.

Description 

The DROP OPTIMIZER STATISTICS statement resets optimizer statistics. The query optimizer maintains statistics as it evaluates queries, and uses these statistics to make better decisions when 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 can help you understand the process used by the optimizer.

Standards and compatibility 

• SQL/92     Vendor extension

• Sybase     Not supported by Adaptive Server Enterprise.