Statement Worst Preparation Time


 
Snapshot Level
Statement

 
Logical Data Grouping
dynsql

 
Monitor Switch
Basic

Resettable

No

 

Element Name
Element Type

prep_time_worst
water mark

 

Description:  The longest amount of time in microseconds that was required to prepare a specific SQL statement.

Usage:  Use this value in conjunction with "Statement Best Preparation Time" to identify SQL statements that are expensive to compile.